Loading from the database
by Jonathon Stevens · in Torque Game Engine · 01/14/2006 (10:25 pm) · 1 replies
I've read a few posts about people who have short hang/lag times while retrieving data from a database. What I'm wondering is, if I have a seperate login server, would it be a good idea to load all the data from the database into datablocks and then don't touch the db again until the character needs to be saved, which shouldn't really hang anything. Am I way off base?
About the author
With a few casual games under his belt as CEO of Last Straw Productions, Jonathon created the increasingly popular Indie MMO Game Developers Conference which. Following the success of IMGDC a new MMOG fan event called LFG Expo will debut in June of 2010.
Torque Owner Stefan Lundmark
Anyway.
Some do the writes in batches, or based on events (picking up a item, would be such an event). That's where you might see slowdowns.
I have yet to see the huge slowdowns talked about in other threads, though.