On Feb 5, 2008 9:33 AM, MB Software Solutions < [EMAIL PROTECTED]> wrote:
> Stephen Russell wrote: > > It is the most costly thing to do is to get a connection. In the end > your > > not getting ANY DATA, just a token. > > > > That's exactly why I wanted to get the connection only when needed > (i.e., when it was no longer active after trying it first). > > ------------------------------------------------------------------------ This is such a multi layered environment that you can get bit. You have the communication layer for a cache potential, the data layer for another, the server itself as a third layer. I know that there was a huge improvement in using server caching for ASP.NETdata and by call we could override the cache and go direct to disk or keep what was in the cache and skip that pesky query all together. Apache plays this game and so does java in a number of add ons. IIS does this but so does Oracle and DB2. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
