[dcayce]

server is configured as follows

OS : NT Server 2000 Advanced

webServer : Tomcat v5.0.12

Java : java sdk v1.4.2

mySQL: v5.0.1

SQLyog: v3.71

mySQL setup with default settings

If you need more info just let me know

dcayce

[dcayce]

You are correct in saying that one does not normally run a query with the intended result set being the entire table. However, when populating a table for the first time, which is my case, it is advisible to at least give all of your data a “is this what I want” look see.

The question still remains, however, why is Microsoft Enterprise Manager faster ? Is it because it starts displaying the query results before it has finished creating the result set. What would you suggest as a pratical limit, row wise, for a returned result set be. Would result sets of three – five hundred be to large in your estimate. Since this server will be going onLine in a two – three weeks I have very little time to test and tune.

Don't mean to ramble and thanks for the advice

[Author]

Posts