hi
I have 2 databases (the size are same). When I sue my VB program to save data to mysql, it is much faster than SQL server. I have checked all the indexes on the relevant tables but still slow. For a data that takes 2 sec to save in mySQL, it takes aound 8 seconds on SQL. Again, the sizes and other characterisics are same for both DB.
I have 2 databases (the size are same). When I sue my VB program to save data to mysql, it is much faster than SQL server. I have checked all the indexes on the relevant tables but still slow. For a data that takes 2 sec to save in mySQL, it takes aound 8 seconds on SQL. Again, the sizes and other characterisics are same for both DB.