SQLite performance impact
 

I've gotten started doing some stuff with SQLite, and now I'm wondering what kind of impact it has on the performance of the server. I got some data stored in the database and I query quite often to get a hold of it when I need it. Would it be a better idea to "cache" the data somewhere or can I keep on doing this?

Some good information here.

Thanks! That helped :)

I prefer to cache mostly static data (weapon stats).

I.e: weapon.arc

WeaponDB.weapon.loadvars("path/to/arcs/weapon.arc");

It's a lot easier to access down the run, and you won't have to update a table if you need a new variable.

But for player and item storage, SQL all the way.