Re: [sqlite] SQLite locking problem with mozStorage

2009-08-16 Thread Sebastian Arcus
Hi Simon and Roger, Simon Slavin wrote: > On 15 Aug 2009, at 9:58am, Sebastian Arcus wrote: > > >> I've just noticed another interesting thing. A read operation after a >> write on same table (like a SELECT statement after an INSERT) works >> perfectly fine - instan

Re: [sqlite] SQLite locking problem with mozStorage

2009-08-15 Thread Sebastian Arcus
Roger Binns wrote: > > Sebastian Arcus wrote: > >> Hi and thanks for the suggestion. I did as you advised and ran 'vmstat >> 1' in a terminal. Very little activity - maybe 20-40kb every 6-7 seconds >> on the bo - pretty much nothing on bi. Also

Re: [sqlite] SQLite locking problem with mozStorage

2009-08-15 Thread Sebastian Arcus
Roger Binns wrote: > > Sebastian Arcus wrote: > >> Hi and thanks for the suggestion. I did as you advised and ran 'vmstat >> 1' in a terminal. Very little activity - maybe 20-40kb every 6-7 seconds >> on the bo - pretty much nothing on bi. Also

Re: [sqlite] SQLite locking problem with mozStorage

2009-08-14 Thread Sebastian Arcus
Roger Binns wrote: > Sebastian Arcus wrote: > >> The SQLite documentation talks about entire database locks by operations >> of the order of milliseconds - 10 seconds seems a long way off. >> > > There is a possible but unlikely cause for what you are

[sqlite] SQLite locking problem with mozStorage

2009-08-14 Thread Sebastian Arcus
Hi all, I'm using the mozStorage implementation from Mozilla foundation, with Javascript and XUL (for the UI) to build a business-type app. I'm having this problem where I seem to get a lock of about 10 seconds after a read operation on a table, before I can perform a write operation on the