:
> - 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
- 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: [sqlite] Is using max(rowid) instead of count(*) safe?
"
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 u
> -Original Message-
> 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 P3
Toulouse, 1872 .
>
>
>
> -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ì 2
: 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:
> I wonder if I could use max(rowid) safely instead of count(*). Does
> rowid increments by 1 for each n
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
Pasteur'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(row
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).
> >
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
_
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
11 matches
Mail list logo