Re: [sqlite] Windows problem when updating

2006-04-05 Thread Milton Sagen
I'd assume that something like that is exactly what's happening since the problem only happens after a reboot, although I was thinking that sqlite was caching it to a temp file or something. I'm running Windows XP Pro but I haven't done anything to change the default behavior of the os. O

Re: [sqlite] Windows problem when updating

2006-04-05 Thread Jay Sprenkle
On 4/4/06, Milton Sagen <[EMAIL PROTECTED]> wrote: > After a machine restart the first time I try to change a field in a > record, on Windows, it takes an inordinately long time for the sqlite > code to return, the amount of time is dependent on the size of the > database but even for a 20 Meg one

[sqlite] Windows problem when updating

2006-04-04 Thread Milton Sagen
After a machine restart the first time I try to change a field in a record, on Windows, it takes an inordinately long time for the sqlite code to return, the amount of time is dependent on the size of the database but even for a 20 Meg one with about 4000 records, the time is in the order o