Running real slow

Hi,

I just downloaded MySql using Windows XP. It takes at least 30 seconds
to open a recordset. What am I doing wrong?

Thanks
Joel

Re: Running real slow

On Tue, 28 Mar 2006 13:03:23 -0800, Joel 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.

Re: Running real slow

Joel wrote:


> Hi,

> I just downloaded MySql using Windows XP. It takes at least 30 seconds
> to open a recordset. What am I doing wrong?

> Thanks
> Joel


The answer is 42.

many, many other sarcastic remarks removed.

As Robbie the robot says; need more data.