Any problems for returning a long long record ....????

<i><b>Originally posted by : Owen Yuen (owen_yuen@yahoo.com)</b></i><br />Hi all:<br />I do have a project that need to query & return all record on web page(INTRANET ONLY). My clients that they don't want to have <Next> & <previous> button for display record ....100-200, 201-300 so on. They want everyting will come out at once after pressing search button& let user to scroll all the way down.<br /><br />Question?<br />I knew it will return a long record sometime if condition match. Any problems or issue that I need to consider that situation. Will user machine will hang up if long long reocrd returning. Total amount of this DB estimate 1 million record in it.<br /><br />If you don't mind, this is my personal email , hope all expertise can give me some HINTS on it.<br /><br />Thanks<br />Owen<br />owen_yuen@yahoo.com<br />