How to speed up when result return by sql statement is too large?

<i><b>Originally posted by : Sam (keong0907@yahoo.com)</b></i><br />Hi, will really appreciate on someone that can help on that problem. <br /><br />Problem: <br />I am using a recordset object to hold the catalog items and when i got the result after execute the sql statement, it return about more than sixty thounsand items. When i try to display such items, it make the script time out. Of course it is extreme slow as well. <br /><br />Just wondering is anyone have any suggestion to solve those kind of case? and the return result is a must? <br /><br />Will be really appreciate for your kindness. Thanks!<br /><br />