Your developers aren't unique :-) personally, I don't see any evildoing in caching some stuff on the client side.
Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 4:24 PM > Hi All, > > We have an application which executes one sql > statement more than 10 million times a day. Everything > is good about the sql, well tuned, uses indexes, parse > only once, etc. The number of concurrent users in this > database seems to around 60, but we see an average > 1500 executions/sec. > > We questioned the developers about the sql as we had > seen 80% to 95% latch sleeps on library cache > constantly. They seem to be hitting the database every > time a page is refreshed instead of storing the > retrieved data some where for later use. > > The developers are of the opinion that cookies and > session variables are considered "the much > detested and reviled Satan and Lucifer of all > "stateful" web apps". > > Any comments/opinion? > > __________________________________________________ > Do You Yahoo!? > Yahoo! Health - Feel better, live better > http://health.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Johnson Poovathummoottil > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
