Too Slow Speed In VB 6.0

[vishal]

Respected Sit / Madam,

I was motivated by your site and much inspired to convert my software from Microsoft
Access To MySQL. But when I implement it there was a problem with MySQL about speed
matters. Here by I have attached a code which represents the timing taken to store the
500 records both in Access and MySQL. Yet this code was programed by the reference given
from your website.

It might be my mistake but please inform us whatever the solutions may be or not.

Thanking You and Congratulation for a Great Revolution over the field of RDBMS. 

Eagerly waiting for your solution to implent the MySQL.

Details for the Test :

Platform         :     Windows 2003 Server
Langauage     :     Visual Basic 6.0 (SP 5)
Connectivity   :     MySQL 3.5
RDBMS         :     MySQL 5.0

From Vishal Panchamia