Bug #10203 <>
Submitted: 27 Apr 2005 14:16 Modified: 27 Apr 2005 16:00
Reporter: R M Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51.11 OS:Windows (XP SP2)
Assigned to: CPU Architecture:Any

[27 Apr 2005 14:16] R M 
Description:
I use MySQL 4.1.11-nt. 
I have experienced a serious performance problem.

When I want to create a database, create a table and add some records to this table, using a script file, MYSQL works terrific!
(mysql -uUser -pPassword < myscript.txt)

However, when I try to add records from VB6, the time it takes to add 1 record, is about 2 seconds! So adding 1000 records took me about 30 minutes....

I have tried to run the VB6 program on another machine (Windows 2000, Mysql 4.1.11-nt, MYODBC 3.51.11) and then the program works fine too.

IS there something I missed?

Regards,

Richard

How to repeat:
?

Suggested fix:
?
[27 Apr 2005 16:00] Hartmut Holzgraefe 
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.