Re: [sqlite] sqlite3 very slow even after creating without rowid

On 1/24/15, Keith Medcalf wrote: > > You are using a WITHOUT ROWID table. Any particular reason why? I suggested to him that it might be faster. Apparently I was wrong. :-\ >Have you > tried using an ordinary table? > What type is your "TIME" field? Or did you mean TEXT

Re: [sqlite] sqlite3 very slow even after creating without rowid

You are using a WITHOUT ROWID table. Any particular reason why? Have you tried using an ordinary table? What type is your "TIME" field? Or did you mean TEXT but misspell it? Do you want the primary key columns to contain null, or is just defining things that are NOT NULL as being nullable

Re: [sqlite] Buffered stderr on Windows (Take 2)

> Date: Sat, 24 Jan 2015 07:18:46 -0500 > From: Richard Hipp > > On 1/24/15, Stephan Beal wrote: > > On Fri, Jan 23, 2015 at 5:18 PM, Guilhem Malichier > > wrote: > > > >> I've been experiencing an issue with SQLite's CLI tool on

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

On Tue, 20 Jan 2015 12:12:00 + "Parakkal, Navin S (Software Engineer)" wrote: > Hello, > >I've few questions about sqlite3 , the database it creates. > Actually I'm finding lot of differences in performance. > > My story: > I have this sqlite3 database

Re: [sqlite] database locked in PHP

On Sat, 24 Jan 2015 20:59:22 + Simon Slavin wrote: > and set it to 6 (60 seconds) or so. Okay, I try that, but I still don't understand how can a single threaded application get a locked error. Levente

Re: [sqlite] Advice needed for optimization options

On Mon, 19 Jan 2015 13:30:24 -0500 Andy Jewell wrote: > I have a single threaded application, which at its heart is > > while (true) { > open a database // any one of thousands, so I can’t just keep > it open do a select > close the database > } > > With that part

Re: [sqlite] database locked in PHP

On 24 Jan 2015, at 8:13pm, Lev wrote: > I sometimes get a database locked error when I access the database by > calling the execute() call. This is on PHP. Have you set a timeout ? Immediately after opening the connection use

[sqlite] database locked in PHP

Hi list, I'm currently working on a www frontend that uses SQLite. I sometimes get a database locked error when I access the database by calling the execute() call. This is on PHP. Reading the document http://www.sqlite.org/rescode.html#locked I learned that locked error occurs only on the

Re: [sqlite] Buffered stderr on Windows (Take 2)

On 1/24/15, Stephan Beal wrote: > On Fri, Jan 23, 2015 at 5:18 PM, Guilhem Malichier > wrote: > >> I've been experiencing an issue with SQLite's CLI tool on Windows 7, when >> used through a script or spawned process (not when used directly in the >>

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

Hi, Relying on sequence will not work (and is a wrong hack) since the use case includes deleting rows explicitly. I think it's time for a serious simple benchmark with sqlite and say PostgreSQL. PostgeSQL also had performance problems time ago but this has been resolved. Can you describe the

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

Jim Wilcoxson wrote: > If you have a table where rows are inserted but never deleted, and you > have a rowid column, you can use this: > > select seq from sqlite_sequence where name = 'tablename' This works only for an AUTOINCREMENT column. > This will return instantly, without scanning any rows