Zonet
Web Developer
Stian, can you explain what are the benefits of moving map from .otbm to sql?
There's no difference, SQL saves it as Binary same as OTBM (Open Tibia Binary Map)
Stian, can you explain what are the benefits of moving map from .otbm to sql?
There's no difference, SQL saves it as Binary same as OTBM (Open Tibia Binary Map)
It's a lot of diffrent I guess.
SQL = Much less size = You don't need so much RAM. = MORE RL MAPS = SUCKS
Both are saved as Binary = same shit.
Real Time queries to load the map (Like WoW servers), no more need to wait until the map load at the start, no more 5gb+ ram usage only just because of big maps, and you no longer will waste a quadcore (Or More) while hosting ots , etc etc etc!
This also make it way more easy (And more reliable) to make APPS for it.
To update the map./reload map fromX toX fromY toY
Well. Today we load everything at startup. It wastes alot of resources holding the map. OTBM is not a format made for dynamic loading and it would therefore not be possible to make a propper "as-needed loader" for that structure. With SQL, you can easily get only the parts of the map you need.
And to all that are afraid of realmaps. Note that the search time will be LONG if you don't optimaze the database for such a big map. Real maps with stock XAMPP will be unplayable.
You can also do something like this:
To update the map.
OT is dead anyways.
Real map servers has killed it and it's not even custom.
Well, I was going to rewrite the entier SQL system. Mysqlnd and then spawn a connection for every thread. Might move all the map update things out of the main. And you guys is doing something wrong. I've never got the lost connection to MySQL error.
Sorry for offence but you are going to rewrite everything in TFS. Lol.
So far I heard about python scripts, revscriptsys etc, maybe I'm just blind but I can't see any result of your words : <
Nevertheless, I still hope that you are working on it.
Mysql maps would be great feature. You should also consider memcache feature : )
I suppose that this server: HG 2010 Extra Large dedicated server file - OVH
(Intel Bi Xeon E5530 2x 4x 2x 2.40+ GHz, 24 GB DDR3 ECC) will allow us to host 30-40 real maps with 100 ppl on each. _/