remote: warning: GH001: Large files detected. You may want to try Git Large File Storage - https://git-lfs.github.com.
remote: warning: See http://git.io/iEPt8g for more information.
remote: warning: File data/sql/base/db_world/broadcast_text_locale.sql is 72.88 MB; this is larger than GitHub's recommended maximum file size of 50.00 MB
remot
Max size is 100MB I think, should we worry ?
Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.
we should not worry, however we should at least remove big files from the git history
Let's divide his queries by languages (each lang into a separate file)
Personally I have issues when trying to import broadcast_text_locale.sql from base to DB, could that be due to it being too big?
https://gist.github.com/Kitzunu/d146b76e4104ba3120cafa4e3208c0a5
Some other guy (don't remember) also confirmed that.
The "some other guy" confirms again.
My memory is short sometimes haha, sorry and thanks Lukas 🗡️
I suggest to divide *_locale.sql to 8 different tables:
*_enUS_locale.sql
*_deDE_locale.sql
*_frFR_locale.sql
*_ruRU_locale.sql
and so on.
500 000+ records in broadcast_text_locale is too much ((

I agree that could be a good option
How about you divide (split) source code and database into 2 separate repositories.
This way you will not only make it more readable and easier to track changes but generally better for downloading etc.
How about you divide (split) source code and database into 2 separate repositories.
This way you will not only make it more readable and easier to track changes but generally better for downloading etc.
Originally it was like this in MaNGOS. The problem is that there are often changes involving both the C++ and the DB, that's also why TrinityCore/CMaNGOS went for the monorepo approach, which we inherited.
Currently only the table broadcast_text_locale.sql exceeds the limit of 72mb, being it 76mb.
My proposal for this issue is to make the localization as a module and support in the core only the English version.
I'm not happy with this @Hacaw and i think others will agree with me. Also i use deDE Client and the Blizzlike Core should work with different languages so there should be no mod with localisation tables.
My proposal for this issue is to make the localization as a module and support in the core only the English version.
Usually, I'd say the more things can go into modules the better. But in this case, I agree with @LukasVolgger as a server should support any language. You can have different clients with different localisations connecting together.
Most helpful comment
Let's divide his queries by languages (each lang into a separate file)