On Tue, 28 Mar 2006 13:03:23 -0800, Joel <jo**@ecsnj.com> wrote:
What am I doing wrong?
Well, one thing you're doing wrong is asking a question without giving
enough context. ;-)
It'd help if you described as much as possible of the following:
- The version of MySQL. Since you just downloaded it, should we assume
5.0.19?
- What SQL query are you trying to run?
- Have you tried using EXPLAIN to report how the optimizer treats your
query?
See
http://dev.mysql.com/doc/refman/5.0/en/explain.html
- Do other queries run faster?
- Is it consistent that the one query runs slowly and others run faster?
- What client interface are you using (e.g. JDBC, ODBC, C API, etc.)?
- What programming language (e.g. VB, Java, PHP, C++, etc.)?
- Can you show the code you use to open the recordset?
- The expected size of the query result set. 10 rows? 10,000,000 rows?
- What is your machine's processor, and memory?
- What clues can you get from Task Manager about resource usage?
- What other applications may be competing for resources?
Regards,
Bill K.