Re: [sqlite] Performance problem with simple queries

2007-02-12 Thread John Stanton
You are almost certainly encountering disk cacheing effects. Makavy, Erez (Erez) wrote: Problem summery: --- Simple queries sometimes take ~400 ms Analysis: --- - A php script runs the same SQL query several times in different places (in different transactions).

[sqlite] Performance problem with simple queries

2007-02-12 Thread Makavy, Erez \(Erez\)
Problem summery: --- Simple queries sometimes take ~400 ms Analysis: --- - A php script runs the same SQL query several times in different places (in different transactions). Some of the queries take around 400ms while the others (identical queries) takes only 4-20ms.