|
Posted by Eric Layman on 02/05/07 21:11
Hi,
Many years ago when I first learnt abt web dev in school,
I was taught this methodology:
[Open connection]
<html>
blah blabh
[execute sql]
[loop thru recordset]
<table>[data] </table>
[recordset close]
[end loop]
<html>
[Close connection]
Over the peroid of time, I noticed that the above method may cause
connection problems on heavy sites.
Recently, I have use another method to retrieve data from server
[Open Connection]
[declare 2D array]
[loop thru recordset]
[2D array] = [data]
[recordset.close]
[end loop]
[Close connection]
<html>
[loop thru the 2D array]
<table>[2d array's DATA] </table>
[end array loop]
</html>
It performs better as all the data retrieveal and processing are all
processed at the beginning of the page.
Need comments and advise please.
1. Are there better ways to manage connections and easier data retrieval to
ensure performance of the site under heavy load?
2. Are there any potential pitfalls regarding my 2nd method of data
retrieval?
Thanks
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com
[Back to original message]
|