> Doesn't sqlite "know" the number of rows in each table without
> explicitly counting them? Thanks for any help Buzz
No it doesn't know that. One thing you could try using is triggers.
eg. Set a trigger to increment a value in some other table when a
row is inserted, and decrement the value
-Original Message-
From: Buzz Weetman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 7 January 2004 7:43 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] need faster count(*)
In my particular situation, count(1) or count(my_column_name) does not
seem to make a dent. I understand that count(x
2 matches
Mail list logo