Thank for reminding me to check the obvious. The server was using version 3.6.20. I manually upgraded to version 3.8.10.2 and the query completed in 16 seconds. Still not as fast as my home PC but given the age of the hardware, this is understandable. I will take 16 seconds as opposed to 40+ minutes any day!
- [sqlite] Query takes 8 seconds on one machine but I abort a... rotaiv
- [sqlite] Query takes 8 seconds on one machine but I ab... Richard Hipp
- [sqlite] Query takes 8 seconds on one machine but ... John McKown
- [sqlite] Query takes 8 seconds on one machine but ... rotaiv
- [sqlite] Query takes 8 seconds on one machine but I ab... Simon Slavin
- [sqlite] Query takes 8 seconds on one machine but ... Igor Tandetnik
- [sqlite] Query takes 8 seconds on one machine ... rotaiv
- [sqlite] Query takes 8 seconds on one machine ... Simon Slavin
- [sqlite] Query takes 8 seconds on one mach... Andy Ling
- [sqlite] Query takes 8 seconds on one mach... Marc L. Allen
- [sqlite] Query takes 8 seconds on one... Reinhard Max
- [sqlite] Query takes 8 seconds on... Marc L. Allen
- [sqlite] Query takes 8 second... Reinhard Max
- [sqlite] Query takes 8 second... Marc L. Allen