Am 25.01.2012, 15:27 Uhr, schrieb Piotr Oh
Assuming the usage of the kinterbasdb firebrid driver, the most efficient way would be to send a list of tuples as parameters for such a Update/Insert statement. The statement would have to be only prepared (pseudo-compiled, whatever) _once_ at the server side. And the number of network roundtrips will also be minimal.
And what about odbc driver? which one of them would be more straightforward? simpler etc?
Kinterbasdb exposes the DB-API 2, that was mentioned by Stefan, as far as I know, the ODBC driver does the same. But I would surely go for the native driver, as you get additonal access to the firebird specific service API (backups, restores, statistics, monitoring and stuff). And if one of both is more efficient, it's pretty much guaranteed to be the native one. --dirk