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

Re: List of ports which should be opened for IPTABLES

2007-03-04 Thread Stewart Smith
On Tue, 2007-02-27 at 10:59 -0500, Agarwal, Abhishek wrote: Hello All, Does anyone know a quick reference which details a list of ports which are used my various machine in the MYSQL cluster environment. We just installed the MYSQL cluster and have the IPTABLES shutdown as we are not sure