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?

P.