> What language and/or wrapper library are you using to drive SQLite?
>
> Also, how large are the records in your database? You said earlier that
> they have 45 fields, but not what type of data was stored in any of
> them. Since you are doing string searches, I assume that at least one
> contains
Carl Jacobs wrote:
I'm using Windows XP Sp2, SQLite3.DLL V3.2.7. One of the tests which follows
was repeated with bleeding edge SQLite3.DLL V3.3.1 - and gave the same
result.
If I do the following query 'SELECT count(*) FROM MyTable' then when I time
the process I get the following results:
On 1/16/06, Carl Jacobs <[EMAIL PROTECTED]> wrote:
> The only thing that seems to make it quick again is terminating and
> restarting the process - i.e. shutting down and restarting my program. It
> seems that no matter what I do it's quick for about 5 queries, and then
> seems to fall in a heap.
Hello, sorry for the lengthy email.
I feel like I'm missing something, but I don't know what - is there anyone
who could at least help me with a direction to search in.
I'm using Windows XP Sp2, SQLite3.DLL V3.2.7. One of the tests which follows
was repeated with bleeding edge SQLite3.DLL V3.3.1
4 matches
Mail list logo
