Re: MySQL and VBquestion - problem with query that returns 100000+ records

[Brent Baisley]

I have to ask, why would you even want to pull that many records at 
once? No user would want to sift through that many records. I always 
add a limit clause to all my queries. There is no harm in having a 
limit 500 when you are just receiving 10 records. But it's good to have 
the limit there in case your query has a "bug".

It may be that things are hanging on the transfer of that much data 
from MySQL to ODBC to VB. If you add a LIMIT 25 at the end of the query 
statement, does it work then?

On Jun 30, 2004, at 11:52 AM, Greg Zimmermack wrote:
Victor
Thanks for your reply.
I checked the processlist and it continues to execute even after the 
VB application is hung. I know the application is hung by checking its 
status in the Windows Task manager.

The 'hostname.err' file did not show any errors. Is there another file 
i should be looking at?

The error handler in in VB could not handle the error.
Is there some ODBC setting I need to optimize?
Any help will be appreciated.
Thanks
Greg
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]