This will be a big overhead on really small queries.... I need to be able to say roughly how many rows, but obviously the exact number would be good. Some queries are very time critical and complex so I don't want to have to do a COUNT(*) on them.
-----Original Message----- From: Scott Baker [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 4:10 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Row Count SELECT count(*) FROM Table WHERE Foo = 'bar'; ???? Drew, Stephen wrote: > Hello, > > Is there any way to obtain the number of rows returned by a SELECT > statement, before receiving all the rows returned? I am using the > sqlite_exec() / sqlite_step() functions to return the data, but need > to populate a progress bar. > > Regards, > Stephen Drew
