You commit a transaction using:but where to specify the commit "n of 256".
SQLTransact(SQL_NULL_HENV, hdbc, SQL_COMMIT);
There is no way to set an automatic 'commit interval'. Your code needs to make thsi happen by issuing a commit every 'n' inserts.In JDBC
In JDBC you turn autocommit off using the setAutocommit() method on a JDBC Connection object and you commit using the commit() method on the JDBC >Connection object.since i am database developer i am not sure where to use the setAutocommit() and commit() in my code
What I do know is that you are not really just using ODBC here.for creating the connection i have used
There are several C# and .NET layers between your code and the TimesTen ODBC driver and I suspect that is contributing to the slowness.so how can i optimize the code