|
TStewartFan
Junior Member
190 Posts |
 Posted - 13 February 2005 : 16:44:41
|
I have finally reconfigured all the MODs I need for my site implementation and wanted to work on minimizing all these multiple connections to the database. Question of the day for you guys. If I utilize the already pre-existing connections (established in the default inc_header) and predefine items I will randomly be utilizing throughout the site (much like the MemberID) will I gain or loose performance? For instance, in my inc_header I have a select statement that calls upon a conditional WHERE statement (where MEMBER_ID=" & MemberID) Would it be beneficial (the amound of times I need to connect to the db) to save instances of the values it pulls from the db into a variable. Meaning
select * where member_id = "& memberid
MemberPoints = rs("M_POINTS")
MemberROnly = rs(M_READ")
and so on and so on...
Because the inc_header is included in each page and the rs connection is created in each page it would save me the hastle of having to create 2, 3, 4, ect.. connections to the db from my included files. Could this method be bandwidth beneficial or would I be just increasing the time it takes to load each page? From what I have learned with ASP and from what I know with Javascript I would think by saving the info into a variable which is used across multiple pages it would decrease load time but because many of these variables will only be used once or twice throughout the site would it be that much of a benefit? I figured I would ask BEFORE I began to change because I have more then my fair share of included files  Thanks for all your help. Just trying to make my site as dial up friendly as possible while still keeping the cool stuff I hope my site will be the only site offering.  |
|
Topic Locked
