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

[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] count(gid) takes too long

Hi, This is on a NFS on Windows XP Xeon - 2.8 Ghz, 1 Gig RAM and the database size is 395 MB. I'm connecting to the database from Perl. There is no discernible difference b/w Perl and sqlite shell. Raj On 8/29/06, Martin Jenkins <[EMAIL PROTECTED]> wrote: Sripathi Raj wrote: > Main

[sqlite] sqlite_master

Hi, What's the schema of sqlite_master? I'm trying to find trigger entries. Thanks, Raj

Re: [sqlite] count(*)

There are no deletes on this table though. On 7/19/06, Sripathi Raj <[EMAIL PROTECTED]> wrote: What does LIMIT 1 do? On 7/19/06, Brannon King <[EMAIL PROTECTED]> wrote: > > >> select rowid from table limit 1 offset -1; > > Two ways to do this: > >

Re: [sqlite] count(*)

What does LIMIT 1 do? On 7/19/06, Brannon King <[EMAIL PROTECTED]> wrote: >> select rowid from table limit 1 offset -1; > Two ways to do this: > >SELECT rowid FROM table ORDER BY rowid DESC LIMIT 1; >SELECT max(rowid) FROM table; Yes, but neither one of those would be as fast as this

Re: [sqlite] count(*)

Never mind, it was a problem with the disk. On moving to a faster disk, the time taken dropped to 8 seconds which I guess is still slow. Raj On 7/18/06, Sripathi Raj <[EMAIL PROTECTED]> wrote: Hi Jay, I have a database whose size is around 250 MB. I have a table which has around 1

[sqlite] count(*)

Hi, I read in one of the threads that count(*) has to be hand optimized since SQLite doesn't optimize it. Any pointers on how to do that? Raj

[sqlite] SQLite timeout

Hi, What is the default busy_timeout in SQLite? When we set busy_timeout how often does it try to execute the query? What happens when we get a connection to the SQLite from Java? Does it get a filehandle or does it lock the file? Thanks, Raj

Re: [sqlite] Read-only mode

t;Read-Only mode". If you create a database, and later change the file permissions to have read but not write; you can still read the database from command line [and should be able to from perl DBI]. Hope this helps, Christian Werner -Original Message- From: Sripathi Raj [mailto:[EMAIL

[sqlite] Read-only mode

Hi, What's the Read-only mode used for in SQLite? How do I specify that the SQLite database should be opened in the Read-Only mode? I'm accessing SQLite from Perl. Thanks, Raj

Re: [sqlite] DBD Sqlite

On 4/4/06, Nathan Kurz <[EMAIL PROTECTED]> wrote: > > On Tue, Apr 04, 2006 at 04:18:35PM -0700, Sripathi Raj wrote: > > On 4/4/06, Nathan Kurz <[EMAIL PROTECTED]> wrote: > > > > > > > >> 3. The performance for inserts is really bad. Around 40k en

Re: [sqlite] DBD Sqlite

On 4/4/06, Nathan Kurz <[EMAIL PROTECTED]> wrote: > > > >> 3. The performance for inserts is really bad. Around 40k entries > takes a > > >>few hours. What might I be doing wrong? I do a commit after > > >>all the inserts. > > > > > > A few things to help with speed: > > > > > > 1. Use

Re: [sqlite] DBD Sqlite

Darren Duncan wrote: > At 15:03 -0700 4/4/06, Sripathi Raj wrote: >> Hi, >> I have a few questions regarding SQLite. I'm using it on Windows and >> connecting to it from Perl. > > And I will answer some of them. > >> 1. How do I find out if the current version

[sqlite] take_imp_data in Perl DBI

Hi, I'm setting the busy_timeout after I get a connection to the database. I noticed that DBI->take_imp_data() is being called even though my application is single-threaded. I'm not able to reproduce this problem. It leaves my database connection in a zombie state. Has anyone experienced this

Re: [sqlite] SQLite Busy status from DBD::SQLite

ch.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index.htm Here > DBI's author talks about a variety of topics including error handling. It's > beem a good reference for me. > > -Clark > > > - Original Message > From: Sripathi Raj <[EMAIL PROTECTED]> > To: sql

[sqlite] DBD::SQLite

Hi, I'm using DBD::SQlite with Perl. How do I know that the execution of a statement failed because the database was locked? Should I examine the $DBI::errstr? Does DBI set an error code or something? Thanks, Raj

Re: [sqlite] SQLite_Busy from DBD-SQLite

I'm using Perl 5.8.7 on Windows. When the database is locked, the statement execution returns a FALSE value like it does for any other error. On 3/16/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote: > > On 3/16/06, Sripathi Raj <[EMAIL PROTECTED]> wrote: > > Hi, > > >

[sqlite] SQLite_Busy from DBD-SQLite

Hi, How do I know that a statement failed to execute because the database was locked? Raj

[sqlite] Create table IF NOT EXISTS

Hi, Is the IF NOT EXISTS constraint supported? When I try to use it, I get an error message saying that there is a syntax error at 'NOT'? I'm using Sqlite 3 on Windows and I'm trying to connect to it from Perl. Thanks, Raj