Sign in to follow this  
Followers 0
sshrum

SQLite queries SLOOOOOW.

2 posts in this topic

About a year ago I wrote a script that generates a listing of all my music and creates a SQLite database. It contains about 55,000 records.

I've been away from tinkering with my scripts for about a year and recently I went to do a "Select * from Metadata" and noticed something strange...queries take FOREVER (or seemingly freeze). I remember doing queries on this table in the past in like 4 seconds or less.

If I change the SQL query to be "Select * from Metadata limit 0,10000", it's taking 90 seconds to return a 10,000 record result (should be less than a second).

I'm running with the latest SQLite dll v.3.6.19 with the latest AutoIT v.3.3.0.0.

Did something change/happen with autoit's sqlite tie-in? Do I need to go back to a earlier dll?

TIA


Sean Shrum :: http://www.shrum.net

All my published AU3-based apps and utilities

'Make it idiot-proof, and someone will make a better idiot'

 

Share this post


Link to post
Share on other sites



I utilize v.3.6.19 and didn't notice any speed impairments... how do you extract the data? I think I remember _SQLite_GetTable2d() is a bottleneck whereas _SQLite_Query(), While _SQLite_FetchData(), _SQLite_QueryFinalize() is really fast... I guess it's more a problem of how you create the array in AutoIt...

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0