In my multithreaded applications I use sqlite3_busy_timeout(sqlite3*, int ms) to avoid failures on temporary locked databases.
This works fine so far. The only problem is the very poor computer I have to use. I made a test to let 3 applications do nothing, but write to the database. When I use the function with ms=10000 I get much poorer result, than I get when I program the behaviour of the function on my own. I think the reason are the sleep times between the write attempts. I get better results with longer sleep times, because I do not waste so much computing time on write attempts (Of course only valid on my poor machine). First Question: How long does sqlite3_busy_timeout(sqlite3*, int ms) sleep minimal and maximal? Second Questions: Would it be possible the add a function sqlite3_busy_timeout_???(sqlite3*, int ms, int minSleepMs) where the user can define the minimal sleeptime "minSleepMs" between two attempts? Regards, Stefan Best regards / Mit freundlichen Gruessen Stefan Breitholz ----------------------------------------------------------------------------------------------------------- Staeubli GmbH - Theodor-Schmidt-Str. 19 DE - 95448 Bayreuth Phone: +49(0)921/883-126 Fax: +49(0)921/883-58126 mailto:s.breith...@staubli.com http://www.staubli.com Registered under HRB 175 - Local Court Bayreuth - Managing Director: Karl Kirschner ----------------------------------------------------------------------------------------------------------- This e-mail and any attachment (the 'message') are confidential and privileged and intended solely for the person or the entity to which it is adressed. If you have received it in error, please advise the sender by return e-mail and delete it immediately. Any use not in accordance with its purpose, any dissemination or reproduction, either whole or partial, by entities other than the intended recipient is strictly prohibited. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
