Interesting stuff!! Just what I am looking for infact! Our CMS has got the the point where retrieving the documents from SQL2K as XML is causing a delay. If we held all of the documents as a IMBD then its looks as though we can see a massive improvement in response!
I would be interested to know of your experiences of using a IMBD. Dan -----Original Message----- From: Kevin Collins [mailto:kcollins@;art.com] Sent: Monday, October 28, 2002 14:33 To: ActiveServerPages Subject: RE: Measuring memory used in application variables Hey Rob, I was just reading your N-Tier article this morning. Nice job! > Lenb() would be my best guesstimate also. Since it will store it in > Unicode (dual byte code), it would make sense. Thanks, that's what I thought. > Im wondering...why do you need to measure memory? Scalability planning? > Wouldn't such things as session useage, Ado useage, etc. make the > biggest impact and such a significant different the APP variables would > almost be negligable??? Well I'm considering an in-memory database solution as outlined here: http://www.15seconds.com/issue/010409.htm http://www.15seconds.com/issue/010410.htm The idea is to store a ton of data in the application object as a free-threaded MSXML DOMDocument and execute search queries against it using XPath. The author gives benchmark results that show it outperforming standard ADO / SQL Server calls by a long shot. He shows some data on the amount of memory used, but doesn't tell how he measured it. I know I can look at PerfMon or Task Manager before and after caching the data, but using something like LenB() seemed like a more accurate way to measure it. Kevin Collins --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com _____________________________________________________________________ This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
