im taking a long period of time to do SQL insertion.
basically it takes ard 4ms for a record insert. I am using C++ to do my connection to SQL and then using recordsetPtr to open the database. I need to shorten this time taken as im doing some simulation work and real time analysis.
I am using scope_ident() to grab the primary key of a table and insert this primary key into another table. hence i don't think using bulk insert is possible.
Pls help. thank you.
View Complete Post