Re: [sqlite] Query slow on SQLite

2011-01-05 Thread Richard Hipp
On Wed, Jan 5, 2011 at 5:32 PM, Simon Slavin wrote: > > On 5 Jan 2011, at 5:42pm, Peter wrote: > > > Both the last two 'tables' are views of the form I gave above. I'm using > > the same indexes for both SQLite and PostgreSQL. > > PostgreSQL will make up its own indexes if it thinks they will spe

Re: [sqlite] Query slow on SQLite

2011-01-05 Thread Simon Slavin
On 5 Jan 2011, at 5:42pm, Peter wrote: > Both the last two 'tables' are views of the form I gave above. I'm using > the same indexes for both SQLite and PostgreSQL. PostgreSQL will make up its own indexes if it thinks they will speed up a search. Actually, so will SQLite. The problem is that

Re: [sqlite] Query slow on SQLite

2011-01-05 Thread Black, Michael (IS)
[email protected] on behalf of Peter Sent: Wed 1/5/2011 11:42 AM To: [email protected] Subject: EXTERNAL:[sqlite] Query slow on SQLite I have a Python web application that I am converting to use SQLite3 for local deployment instead of PostgreSQL to make it simpler to inst

Re: [sqlite] Query slow on SQLite

2011-01-05 Thread Richard Hipp
On Wed, Jan 5, 2011 at 12:42 PM, Peter wrote: > I have a Python web application that I am converting to use SQLite3 for > local deployment instead of PostgreSQL to make it simpler to install. > > Some queries run up to 50 times slower using SQLite. We can probably help you better if will post yo

[sqlite] Query slow on SQLite

2011-01-05 Thread Peter
I have a Python web application that I am converting to use SQLite3 for local deployment instead of PostgreSQL to make it simpler to install. Some queries run up to 50 times slower using SQLite. They are all doing similar things - extracting the latest record from a change log table using a que