Dominik Fässler <[EMAIL PROTECTED]> said: >>I've read that 'select count(*)...' is faster only if you aren't then >>selecting all of the rows two lines later, in which case there's no >>benefit. Which is to say, there won't be any drawback to eliminating our >>use of num_rows() style functions, except gnarlier code in those places >>:-\ >> > Ok, I will use 'dbi_result_get_numrows' from libdbi.
If the Firebird API does not provide this functionality, then it's not likely that libdbi is adding this functionality. More likely, it's just faking it somehow by retrieving all of the rows, counting them, and caching them with the hope that they'll be requested later on anyways. A numrows() solution will be the quick way to a first version, but we may discover that the performance is terrible and 'SELECT COUNT(*)' is needed. I guess we can cross that bridge if/when we get to it, though! >>As it turns out, libdbi doesn't have support for Firebird. So: >> >>- You can write the Firebird driver for libdbi, >> and we can write the libdbi driver for DBMail or... >> >>- You can write the Firebird driver for DBMail. >> >> > There is a Firebird driver in CVS (libdbi-drivers). Oh, that's excellent :-) Aaron --
