SQLite performance impact

[Crow]

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?

[salesman]

Some good information here.

[Crow]

Originally Posted by salesman

Some good information here.

Thanks! That helped

[fowlplay4]

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

I.e: weapon.arc

PHP Code:

name=whatever weapon
speed=fast
power=high 


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.