Quote:
Originally Posted by sage_chaozu
Then what would one use a SQL lite database for? It's starting to seem like a lost cause due to performance issues. Then again this does guarantee secure data storage and manipulation. I believe this is due to SQL transactions actually locking the DB table before writing to avoid overwriting.
|
It's faster because it uses proper data structures. In particular it uses a B-Tree for each index you make, which allows you to look up a row based on a certain condition in sub-linear time to the amount of rows you have.
It's written in C, so it's implementation of a B-Tree will be far faster than anything you could do in GS2.
Most of the time your entire dataset will be loaded into SQLite's memory anyways so you don't really need to worry about the disk.