Hi Elias, > The problem is that this project is written in C++ and uses > ODBC. As far > as I know there is no prepared statements in ODBC.
Of course, there are prepared statements available (SQLPrepare). And you are encouraged to use prepared statement if you execute the same statement very often. This can considerably accelerate your application since: - the DB kernel has to parse the statement only once - the communication for parsing is only done once If you transfer data which fit into a communication packet (kernel parameter PACKET_SIZE (default ~36KB)), you divide the number of I/O packets roughly by 2, when you use SQLPrepare, SQLExecute, SQLExecute, SQLExecute ... instead of SQLExecDirect, SQLExecDirect, SQLExecDirect ... Furthermore you relieve the kernel from doing the same over and over again. Ok, there might be DBs which only pretend to support SQLPrepare and do actually more a SQLExecDirect, or even expand the bound parameters within the statement and send the whole thing to the DB server. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
