MobileRead Forums - View Single Post

HarryT · 08-11-2014, 08:34 AM

There's certainly nothing obviously amiss with those SQL commands that I can see. An indexing issue does seem quite likely - with 3500 books in my database, a full table scan (especially if it's doing joins to other tables) could be very slow.

08-11-2014, 08:34 AM	#33
HarryT eBook Enthusiast Posts: 85,557 Karma: 93980341 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	There's certainly nothing obviously amiss with those SQL commands that I can see. An indexing issue does seem quite likely - with 3500 books in my database, a full table scan (especially if it's doing joins to other tables) could be very slow.