View Single Post
  #2  
Old 12-07-2005, 06:18 AM
jami jami is offline
OSP Starters
 
Join Date: Dec 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jami is on a distinguished road
Default Suggestion

Using transactions only boosts performance if you do more than one insert / update.

You might want to consider setting the async option (if indeed, it exists)

Mounting the filesystem your databases are on with the "noatime" option might help.

Another thing to check is whether your filesystem has data journalling on - if so, this is a bad idea for performance. Data journalling is not the same as filesystem journalling. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - Trouble with PHP5/SQLite
View Single Post
  #2  
Old 12-07-2005, 06:18 AM
jami jami is offline
OSP Starters
 
Join Date: Dec 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
jami is on a distinguished road
Default Suggestion

Using transactions only boosts performance if you do more than one insert / update.

You might want to consider setting the async option (if indeed, it exists)

Mounting the filesystem your databases are on with the "noatime" option might help.

Another thing to check is whether your filesystem has data journalling on - if so, this is a bad idea for performance. Data journalling is not the same as filesystem journalling. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote