[sqlite] Horrendous slowdown when updating versions
Hi all, I was running a system using an old sqlite3.dll (version 3.0.8, I believe). Updating to the latest version (3.6.23) causes my program to run incredibly slowly. As an example, selecting approximately 30,000 records was taking 10 seconds with the old dll, and with the updated version takes 70 seconds. Whereas 10 was just about acceptable, 70 is definitely not; can anyone think of a reason why this might be, and what steps I could take to rectify it? Regards, Ed ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Horrendous slowdown when updating versions
On Tue, Jul 20, 2010 at 7:38 PM, Ed Hawke < edward.ha...@hawkeyeinnovations.co.uk> wrote: > I was running a system using an old sqlite3.dll (version 3.0.8, I believe). > > Updating to the latest version (3.6.23) causes my program to run > incredibly slowly. > > Can you provide more details about the query, maybe narrow it to some easily understandable sql fragment Max ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users