MySQL Forums
Forum List  »  Performance

ADO/ODBC Insert performance
Posted by: Frederic Vicinenzo
Date: October 13, 2004 06:25AM


I am using ADO with MyODBC under MS VC++

I need to insert records at very high speed in database (less than 10ms)
Actually, I can have more than 40ms to insert 1 record (depending table)

For create records, I use following methods of the Recordset object :
- Addnew()
- Fields->GetItem()->Value
- ...
- Update()

The problem is on the Update() method execution : minimum 10ms.

How does Update() method work with the server ?
How can I insert records in the database with time less than 10ms ?
What other solution can I use to do this (MySQL C, embedded server, ...) ?


Options: ReplyQuote

Written By
ADO/ODBC Insert performance
October 13, 2004 06:25AM
October 13, 2004 08:06AM
October 14, 2004 04:23AM
October 14, 2004 05:56AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.