Quote:
Originally Posted by Inverness
Are you using transactions when making changes to the database? And is your items table indexed by account?
If the answer is no to either then I have no sympathy for you because you decided to charge head-first into SQLite without learning how it works.
If you're saving the player's item data en masse to the database then you're doing it wrong. If you only load data from the SQL on login and only save on logout (or periodically en masse) then you're using it wrong.
|
Ahh- yes I am only loading/saving it on login/logout & loading it from the database. What do you suggest using to avoid this?