
06-11-2009, 01:30 AM
|
|
Incubator
|
 |
Join Date: Aug 2004
Location: Houston, Texas
Posts: 3,613
|
|
|
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. |
|
|
|