lokster Posted October 31, 2007 Share Posted October 31, 2007 In my dictionary script, I use the following code to query the words from a sqlite database: _SQLite_SQLiteExe($DBName,"select word from words where word like '" & $sWord & "%' order by word asc;",$sOut,@ScriptDir&"\sqlite3.exe") The problem is, that sometimes this function delays the execution of the script for 3-4 seconds. The database is big - about 100 000 records, but I don't think this is the problem, because most of the time the function works very fast, even when the query returns a lot of results. And for the same word, the 1st time it's fast, and the second - slow... (or the first time slow, and the second - fast). When the function has a delay, the taskmanager shows that sqlite3.exe does not use any CPU resources. Just stays at 0% and waits.... So, what is the problem? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now