Re: [sqlite] performance question: SELECT max(rowid) - 1

Trey Mack wrote: > I have a fairly large table (10million rows) with a simple INTEGER > PRIMARY KEY AUTOINCREMENT field. > > Executing 'SELECT max(rowid) FROM MyTable' is very fast, as is > 'SELECT min(rowid) FROM MyTable'. > > However, 'SELECT max(rowid) - min(rowid) FROM MyTable' is slow > (

Re: [sqlite] performance question: SELECT max(rowid) - 1

base now). Still need an explanation rather than just relying on my own speculation. Cheers guy Guy Hindell wrote: I have a fairly large table (10million rows) with a simple INTEGER PRIMARY KEY AUTOINCREMENT field. Executing 'SELECT max(rowid) FROM MyTable' is very fast, as is 'SEL

[sqlite] performance question: SELECT max(rowid) - 1

I have a fairly large table (10million rows) with a simple INTEGER PRIMARY KEY AUTOINCREMENT field. Executing 'SELECT max(rowid) FROM MyTable' is very fast, as is 'SELECT min(rowid) FROM MyTable'. However, 'SELECT max(rowid) - min(rowid) FROM MyTable' is slow (apparently accessing every r

[sqlite] DROP TABLE slower than DELETE?

Hi all In promoting SQLite 3 (still v3.2.7, so a bit behind the current release) for a new project I have been doing some performance tests and SQLite generally looks very good. However, I have seen one surprising result. My schema is simple, a single table with a simple autoincrement rowid

Re: [sqlite] disk I/O error writing files mounted via samba

Guy Hindell wrote: Guy Hindell wrote: [EMAIL PROTECTED] wrote: Guy Hindell <[EMAIL PROTECTED]> wrote: I would like to use sqlite (v3.3.8) on a linux box (fedora core 5) to read/write a database file in a directory which is actually on a windows share mounted via samba/cifs. I can op

Re: [sqlite] disk I/O error writing files mounted via samba

Guy Hindell wrote: [EMAIL PROTECTED] wrote: Guy Hindell <[EMAIL PROTECTED]> wrote: I would like to use sqlite (v3.3.8) on a linux box (fedora core 5) to read/write a database file in a directory which is actually on a windows share mounted via samba/cifs. I can open the file, and read

Re: [sqlite] disk I/O error writing files mounted via samba

[EMAIL PROTECTED] wrote: Guy Hindell <[EMAIL PROTECTED]> wrote: I would like to use sqlite (v3.3.8) on a linux box (fedora core 5) to read/write a database file in a directory which is actually on a windows share mounted via samba/cifs. I can open the file, and read from it, but w

[sqlite] disk I/O error writing files mounted via samba

I would like to use sqlite (v3.3.8) on a linux box (fedora core 5) to read/write a database file in a directory which is actually on a windows share mounted via samba/cifs. I can open the file, and read from it, but writing produces "disk I/O error" messages (SQLITE_IOERR error code). I can wri

[sqlite] sqlite tuning for db writes?

Hi I'm relatively new to sqlite and this list but I have recently used it (v3.2.7) as an alternative to the db backend of an application which previously used SQLServer or Access as part of a proposed port to Unix/Linux. So far so good - the app works just as it did before with SQLServer. However