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 again until a high number of retries. Using it, I've wrote a >> program which writes data forever on the database, and get the data >> again. So, I get to run 8 instances of this testing program and the >> database seems to answer very well. But even with this tests, >> something seems to be wrong for me, and I'm researching to ensure >> everything will be nice on the new environment. I'll improve the >> database layout for better performance too. >> > Hi, Bruno! > > You might want to take a look at the sqlite3_busy_timeout() function in > the SQLite3 C API - http://sqlite.org/c3ref/busy_timeout.html - which > does exactly that and might free you from the effort of maintaining your > own solution to the same problem. > > > Hope this helps, > > Mihai > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
Mihai, Well, thank you!! I'll remove my code right now and use sqlite's solution. Thank you! []'s _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users