Speed of queries in a MySQL database

2007-03-04 Thread Jonathan Trahair
Hi Everyone. I have just upgraded a Visual Basic 6 project which used an Access database as a data back end, using DAO and SQL strings. The Access database was exceedingly slow, and prone to glitches. I have changed the VB code to ADO, and set up a MySQL database in the hope that the MySQL

Re: Speed of queries in a MySQL database

2007-03-04 Thread John Meyer
Jonathan Trahair wrote: Hi Everyone. I have just upgraded a Visual Basic 6 project which used an Access database as a data back end, using DAO and SQL strings. The Access database was exceedingly slow, and prone to glitches. I have changed the VB code to ADO, and set up a MySQL database in

Re: Speed of queries in a MySQL database

2007-03-04 Thread mos
At 09:21 AM 3/4/2007, Jonathan Trahair wrote: Hi Everyone. I have just upgraded a Visual Basic 6 project which used an Access database as a data back end, using DAO and SQL strings. The Access database was exceedingly slow, and prone to glitches. I have changed the VB code to ADO, and set up