[danux]

Hi,

I'm working on a small CMS engine using PHP and Sqlite database.
I have a table with 8 fields that holds all the site data.

Is it better to connect to database retrieve all data, put it in a array, and make all changes to that array before you rewrite it in database.
OR every time when you want to update data or add new data query database.


10x for your time !

[NeverMind]

ok got ya ..
I think it doesn't matter ..

if you want to add new data then delete old one or update indivdually/whole ..

[danux]

Sorry, my english is not very good !


Is it faster to put all data from databse to an array and make all changes using that array and at the end you update the database(i.e. you call only 2 times SQL when you retrieve data and when you put the new one on) ?
Or every time you want to make any changes you make them directly on the database (i.e. every time you call SQL)

I hope yo'll understand now !

10x for your time !