MySQL Forums
Forum List  »  Performance

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

Hello,

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, ...) ?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
ADO/ODBC Insert performance
6552
October 13, 2004 06:25AM
3603
October 13, 2004 08:06AM
3085
October 14, 2004 04:23AM
2774
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.