Re: [sqlite] SQLite Timeout question

[Sripathi Raj]

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

[drh]

"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

[Sripathi Raj]

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

[Christian Smith]

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

[Ray Mosley]

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