Re: [sqlite] SQLite Timeout question
On 9/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Sripathi Raj" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm setting the sqlite_busy_timeout to 1500 millseconds using my database > handle (DBI). When I lock the database and try to commit, it waits for 7 or > 8 wallclock seconds before giving up. What's the reason for this behavior? > Shouldn't the function return after 1.5 seconds? > On unix, make sure you compile with -DHAVE_USLEEP=1 -- D. Richard Hipp <[EMAIL PROTECTED]> This is on Windows XP.
Re: [sqlite] SQLite Timeout question
"Sripathi Raj" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm setting the sqlite_busy_timeout to 1500 millseconds using my database > handle (DBI). When I lock the database and try to commit, it waits for 7 or > 8 wallclock seconds before giving up. What's the reason for this behavior? > Shouldn't the function return after 1.5 seconds? > On unix, make sure you compile with -DHAVE_USLEEP=1 -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] SQLite Timeout question
Hi, I'm setting the sqlite_busy_timeout to 1500 millseconds using my database handle (DBI). When I lock the database and try to commit, it waits for 7 or 8 wallclock seconds before giving up. What's the reason for this behavior? Shouldn't the function return after 1.5 seconds? Thanks, Raj
Re: [sqlite] timeout question
On Thu, 28 Jul 2005, Ray Mosley wrote: >I am accessing a SQLite 2.8 database from an application running several >Windows systems systems using a NFS shared file. I am using the Tcl bindings >- TclPro 1.4.1. > The default timeout is set to 0; if I want to delay up to two seconds if >the DB is locked, does each application need to set the timeout value, or >only one? The timeout is an application property, rather than a database property, so each application that wants a timeout must set a timeout. Christian -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
[sqlite] timeout question
I am accessing a SQLite 2.8 database from an application running several Windows systems systems using a NFS shared file. I am using the Tcl bindings - TclPro 1.4.1. The default timeout is set to 0; if I want to delay up to two seconds if the DB is locked, does each application need to set the timeout value, or only one? Thanks. -- Ray Mosley