RE: [sqlite] Is using max(rowid) instead of count(*) safe?

2004-03-31 Thread Ali Sadik Kumlali
: > - Forwarded by Ben Carlyle/AU/IRSA/Rail on 31/03/2004 10:13 AM > - > > > Ben Carlyle > 30/03/2004 11:17 AM > > > To: "Balthasar Indermuehle" <[EMAIL PROTECTED]>@CORP > cc: > Subject: RE: [sqlit

RE: [sqlite] Is using max(rowid) instead of count(*) safe?

2004-03-30 Thread Ali Sadik Kumlali
age- > > From: Ali Sadik Kumlali [mailto:[EMAIL PROTECTED] > > Sent: Monday, March 29, 2004 3:09 PM > > To: [EMAIL PROTECTED] > > Subject: RE: [sqlite] Is using max(rowid) instead of count(*) safe? > > > > > > Thanks for taking your time. I'm using

RE: [sqlite] Is using max(rowid) instead of count(*) safe?

2004-03-29 Thread Ali Sadik Kumlali
--Original Message----- > From: Cesare D'Amico [mailto:[EMAIL PROTECTED] > Sent: Monday, March 29, 2004 12:09 > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] Is using max(rowid) instead of count(*) safe? > > > Alle 08:54, lunedì 29 marzo 2004, Ali Sadik Kumlali ha scritto: > &

RE: [sqlite] Is using max(rowid) instead of count(*) safe?

2004-03-29 Thread Balthasar Indermuehle
9, 2004 12:09 To: [EMAIL PROTECTED] Subject: Re: [sqlite] Is using max(rowid) instead of count(*) safe? Alle 08:54, lunedì 29 marzo 2004, Ali Sadik Kumlali ha scritto: > I wonder if I could use max(rowid) safely instead of count(*). Does > rowid increments by 1 for each new row? As prev

Re: [sqlite] Is using max(rowid) instead of count(*) safe?

2004-03-29 Thread Cesare D'Amico
Alle 08:54, lunedì 29 marzo 2004, Ali Sadik Kumlali ha scritto: > I wonder if I could use max(rowid) safely instead of count(*). Does > rowid increments by 1 for each new row? As previously stated, it's not safe. A workaround could be to create an additional table with one field and one row, in

RE: [sqlite] Is using max(rowid) instead of count(*) safe?

2004-03-29 Thread Balthasar Indermuehle
eur's theory of germs is ridiculous fiction." Pierre Pachet, Professor of Physiology at Toulouse, 1872 . -Original Message- From: Ali Sadik Kumlali [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 09:18 To: [EMAIL PROTECTED] Subject: Re: [sqlite] Is using max(rowid) instea

Re: [sqlite] Is using max(rowid) instead of count(*) safe?

2004-03-28 Thread Ali Sadik Kumlali
Bert, Thanks a lot for this unexpectedly quick response :) Ali Sadik Kumlali --- Bert Verhees <[EMAIL PROTECTED]> wrote: > Ali Sadik Kumlali wrote: > > >Hello, > > > >I am working with approximately 3.5 million rows data. As far as I > >see count(*) is very slow comparing with max(rowid). > >

Re: [sqlite] Is using max(rowid) instead of count(*) safe?

2004-03-28 Thread Bert Verhees
Ali Sadik Kumlali wrote: Hello, I am working with approximately 3.5 million rows data. As far as I see count(*) is very slow comparing with max(rowid). I wonder if I could use max(rowid) safely instead of count(*). Does rowid increments by 1 for each new row? Thanks a lot. Ali Sadik Kumlali