Jan. 25, 2012
2:34 p.m.
Piotr Oh, 25.01.2012 15:27:
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?
You won't use the driver directly in your code. Python has a generic API for that (DB-API 2) which you will use instead. Stefan