[CJay9209]

SQLite is just a database system - similar to MySQL but it uses a local database file instead of a full blown MySQL server. When you get right down to it MySQL is faster when your talking about thousands upon thousands of queries to the database but for sa-mp there really is no good reason to go MySQL unless your looking for a few more statistics gathering procedures. SQLite is also technically faster and more efficient than using a standard filesystem but to be honest again the differences are extremely small and in most cases will not make any real noticable difference.

The best way to handle player data is simply to load the database into an array of player info to start and not bother calling any queries to the database unless anything changes. If it changes then you simply change the variable and then save it into the database for that player rather than saving everything at once as alot of systems will do. why write 40-50 variables for the one player when rewriting one is just as easy and way faster right? Thats the main reason i switched to sqlite. Now saying that the business system and the vehicle systems are still on a standard file base which you would think is a bit counter-intuitive when you take into account my preferences - Basically, I'm haveing trouble with the system in SQLite and it takes about 15 minutes for the system to setup for the first time due to the 2001 database insertions per system so 4002 overall which is massive - not to mention the fact the Queries are huge as I'm writing 30+ variables per vehicle to the database and about 18 variables per business. I could switch it over but to be honest the filesystem seems to be working just fine for now and no slower really.

Don't be me wrong though. If I find a good easy way of doing it it'll be done and I am still working on it.