Did you try increasing the page cache size. Your data set is very big.
pragma page_cache = 20000;
This should at least improve the speed for queries.
Clive
"Chris Schirlinger" <[EMAIL PROTECTED]> on 02-02-2005 09:07:49
Please respond to [EMAIL PROTECTED]
To: [email protected]
cc: (bcc: clive/Emultek)
Subject: Re: [sqlite] Not getting the speed I think is possoble. Basic
select statment slow?
> What speed were you expecting?
> Are you comparing it to another database? If so what are the results for that
> database?
Anything better than what we got. The results are the worst we have
gotton from any DB or any self rolled data system (Jet is better, het
shouldn't be better)
After more tests, it is dipping to 10 records per second update time.
Based on the speed showen on the web site, I was expecting to at
least get 1000 records a second updating and somewhere above 10k when
selecting
I am assuming we MUST have mucked something up
