My terribly archaic Database

[cavedude]

Trev, that's a really good thought but the problem is what if down the road we identify those unknowns? Then, we'd have to go through the conversion process all over again. I think the fewer times we convert, the safer and better off all of us will be.

[trevius]

I already explained a bit more about it here:
http://www.eqemulator.net/forums/sho...96&postcount=3

But ultimately, it probably isn't worth the extra effort I guess. I am probably going to have to make changes to that structure anyway soon for SoF to reach full functionality. Luckily, none of the changes I would be making should cause any impact at all on previously saved profiles. I won't be adjusting the size of the structure or adjusting where fields currently are. I would just be adding more stuff in where there are some unknowns currently. If I do have to change anything, I will make sure to run it by you and KLS first, since the risk of issues is high when dealing with the PP. As long as size of the total struct doesn't change and no current field positions change, it shouldn't cause any issues.

Sorry for getting off-topic, but the reason for mentioning it was to possibly help optimize everyone's database a bit.

[KingMort]

Should I be using the launcher???

What Priority should the zones be set at, and world..

King

[John Adams]

I used to debate the pros/cons of both MyISAM and Blobs. Hate them both, because I am a constraint freak (ask LE, I may have convinced our team to use InnoDB for FK constraints ). Saves a lot of processing time cascading updates/deletes within MySQL than having an executable run 15 update/delete queries, but again, just my opinion based on my own analysis and research.

I hate the blobs simply because they are... blobs. Unreadable, unless you convert them... and, well, blobby. It shouldn't matter how the data is stored in the DB, as long as the server/client talk the same blobby language.

And you're right, probably not the place to debate it. But I am still thinking of KM's issue, not really sure why he'd be seeing such poor performance unless the hardware is just utter crap.

[Shendare]

Adding indexes to table columns that are often sorted or filtered by can yield a huge performance boost in tables that are read from often but added to rarely (adding a record takes longer with a large table containing many indexes to update).