|laziness, impatience, and hubris|
Re: Does anyone have a list of 'donts' when optimizing?by wardk (Deacon)
|on Apr 16, 2002 at 14:18 UTC||Need Help??|
one "DO" comes immediately to mind as I have dealt with it recently with a system that went from reasonably few transactions (departmental) to high volume (enterprise wide usage).
If using a database, create as few connections as possible. DB connections are expensive and in a high transaction CGI (as well as non-CGI) scenario, creating multiple connections where less (one is best) will do will have a significant impact on your response time, as well as anyone else you may be sharing db resources with (like listeners).
Of course this suggestion (as well as many others you may receive on this) is really valid for all languages.