Re: [sqlite] SQLite locking problem with mozStorage

2009-08-16 Thread Simon Slavin
On 16 Aug 2009, at 11:55am, Sebastian Arcus wrote: > Just to thank you both for your suggestions and to let you know the > problem is solved. I'm glad you solved it, and thanks for your thanks. In a week like this one it's nice to know I'm doing someone some good somewhere. > I've tried

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 - instantly. Which is bizarre, as I

Re: [sqlite] SQLite locking problem with mozStorage

2009-08-15 Thread Simon Slavin
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 - instantly. Which is bizarre, as I would have > expected a > write to keep a much

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, zeros all around on so/si. >> > > That

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, zeros all around on so/si. >> > > That

Re: [sqlite] SQLite locking problem with mozStorage

2009-08-14 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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, zeros all around on so/si.

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 seeing. In order to > ensure the

Re: [sqlite] SQLite locking problem with mozStorage

2009-08-14 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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 seeing. In order to ensure

[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