Trouble with PHP5/SQLite

[johny]

Hello All,

I'm experiencing performance troubles with PHP5/SQLite (php 5.0.3) on Solaris 9, 10, AIX 5.2 but not on Linux (Suse 9). These troubles happen when using apache but also when using only the PHP binary.

The problem resides in the fact that SQLite consumes all the CPU and is very slow for some reason and I can't identify the cause. When I make a truss, I can see that the operations that need much time are the "writing" statements but why is that so slow.

So far, I've not seen such problems under Linux (Suse 9 Enterprise server) nor under Windows (incredible isn't it? )).

If you have any clue, help me out?
Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[jami]

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 --