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.
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).
I checked out 'dbmail' from cvs-system and be in progress to change
db-interface. Can I add a param 'driverdir' and 'driver' in 'db_param_t'
for configuring the database-driver? If 'driverdir' is NULL then
DBI_DRIVER_DIR would be used (compiled in libdbi).
We're looking to make the database backends loadable. There hasn't been
much discussion yet specifically about how to do this, so feel free to
pick any method you'd like, but be prepared for it to change once it is
discussed on the mailing list and we come to a decision about what to do.
I will add the params 'driverdir' and 'driver' in 'db_param_t'.
Dominik Fässler
