How can I avoid execution time-out error while fetching recordS from MySQL Database?
Printable View
How can I avoid execution time-out error while fetching recordS from MySQL Database?
first I would check for indexes..... there is no reson for sql to get timed out unless there is problem with your table.... or trying to featch thousands of recrods.. all the time use field names in sql insted of * from .... and where clause all the time ...
Thanks Jim
Issue is resolved
followed your tips and specified field names and inserted WHERE clause to limit the number of records fetched at a time.
Its working fine now...
Thanks again