Unanswered: How to speed up Java/MS Access connection
Hello All, I have a contractor writing a Java App to connect to MS Access using JODBC. One of the routines takes 30+ minutes. I wrote the same routine in VB/ADO and it took 4 minutes. Then the contractor rewrote to use MySQL and said it took 2 minutes..
Does anyone else out there have speed issues with Java/Access? Is there a better driver set? Is it reasonable that MySQL is 15 times faster than MS Access?