sherlockhomeboy
Programmer
I'm developing a Web application using the Windows version of MySQL. My Web pages will access the database using ASP/ADO through MyODBC.
Currently, my database has six tables, the largest of which contains about 200,000 records.
When I connect to the database and extract a recordset (using an inner join across 4 tables), the connection takes almost 3 minutes.
Obviously, I'm doing something the wrong way (not necessarily wrong, just not the best method). What is the likely culprit?
Currently, my database has six tables, the largest of which contains about 200,000 records.
When I connect to the database and extract a recordset (using an inner join across 4 tables), the connection takes almost 3 minutes.
Obviously, I'm doing something the wrong way (not necessarily wrong, just not the best method). What is the likely culprit?