Re: [sqlite] Performance Care

2008-08-24 Thread Bruno Moreira Guedes
2008/8/24 Mihai Limbasan <[EMAIL PROTECTED]>: > Bruno Moreira Guedes wrote: >> And even with too many 'locking concurrency', I've done some stress >> testing and SQLite still very well. I've thrown the SQLITE_BUSY errors >> to a retry algorithm, which waits a random time in a time range and >> try

Re: [sqlite] Performance Care

2008-08-24 Thread Mihai Limbasan
Bruno Moreira Guedes wrote: > And even with too many 'locking concurrency', I've done some stress > testing and SQLite still very well. I've thrown the SQLITE_BUSY errors > to a retry algorithm, which waits a random time in a time range and > try again until a high number of retries. Using it, I've

Re: [sqlite] Performance Care

2008-08-23 Thread Bruno Moreira Guedes
> On Fri, Aug 22, 2008 at 7:47 PM, Bruno Moreira Guedes > <[EMAIL PROTECTED]>wrote: > >> Hello, >> >> I have an application which uses SQLite. The program open a sqlite >> database, and have about five instances running at the same time. For >> each instance, it waits for user commands(where the 'u

Re: [sqlite] Performance Care

2008-08-22 Thread Tomas Gold
Bruno, I'm quite new to sqlite but I believe that concurrency may be an issue only for data changes which require db locking. As long as you go with SELECTs, there's not much to worry about. Tomas On Fri, Aug 22, 2008 at 7:47 PM, Bruno Moreira Guedes <[EMAIL PROTECTED]>wrote: > Hello, > > I hav