RE: [sqlite] First query on database takes forever...?

2006-05-01 Thread Mats Gefvert
> I've run into exactly the same thing on both version 2 and 3, commented > on it here before too. What Someone suggested here and it works, is to > initially open and read the file as if it were a data file. I do it 64K at a time. > Then close it and open with sqlite, in my case that took the 30

Re: [sqlite] First query on database takes forever...?

2006-05-01 Thread Jay Sprenkle
On 5/1/06, Mats Gefvert <[EMAIL PROTECTED]> wrote: However, we noticed an interesting thing. When we first open the SQLite database and start running queries on it, the first query always takes an enormous time to complete: up to 30-45 seconds. It's not a really complex query, mainly just a

Re: [sqlite] First query on database takes forever...?

2006-05-01 Thread Bogusław Brandys
Mats Gefvert wrote: Usually Windows XP/SP2. The file name of the database is usually "vision8020" with no extension. That couldn't be a problem, could it? Shut down system restore Pardon? / Mats System restore feature of Windows XP. I'm guessing now... Regards Boguslaw

Re: [sqlite] First query on database takes forever...?

2006-05-01 Thread Teg
Hello Mats, I've run into exactly the same thing on both version 2 and 3, commented on it here before too. What Someone suggested here and it works, is to initially open and read the file as if it were a data file. I do it 64K at a time. Then close it and open with sqlite, in my case that took

RE: [sqlite] First query on database takes forever...?

2006-05-01 Thread Mats Gefvert
> > Usually Windows XP/SP2. > > > > The file name of the database is usually "vision8020" with no extension. > > That couldn't be a problem, could it? > > Shut down system restore Pardon? / Mats

Re: [sqlite] First query on database takes forever...?

2006-05-01 Thread Bogusław Brandys
Mats Gefvert wrote: What system you are using ? If this is Windows XP or 2003, then what is the name of this sqlite database ? Usually Windows XP/SP2. The file name of the database is usually "vision8020" with no extension. That couldn't be a problem, could it? / Mats Shut down system

RE: [sqlite] First query on database takes forever...?

2006-05-01 Thread Mats Gefvert
> What system you are using ? > > If this is Windows XP or 2003, then what is the name of this sqlite database ? Usually Windows XP/SP2. The file name of the database is usually "vision8020" with no extension. That couldn't be a problem, could it? / Mats