Caching an sql table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nemisis - 23 Nov 2006 11:08 GMT

Hi everyone,

I would like to test how big an sql table would be in kb if i put it in
the web cache. I need to do this as i will need to do it for 80
databases! So need to check this information before actually
implementing it.

Does anyone know of a tool where by it will tell me the size of the
cache before and after i put an object into it??

The table will have approximately 300-500 rows and about 7 fields in
each row.

Reply to this Message

Nemisis - 23 Nov 2006 11:35 GMT

Or a could cache an object list, either one, but still need to test the
size once it is in the cache, if anyone can help?

Reply to this Message

Dave Sexton - 26 Nov 2006 08:44 GMT

Hi,

This method will help you to calculate the approximate size of a single row
of data in the database. In managed memory, the average size of a row will
probably be somewhat different. If you feel that your estimates will be too
far off then the only accurate way is to create a prototype application and
test it for yourself using scaled test data (preferably, live data samples).

"Estimating the Size of a Table (Sql Server)"
http://msdn2.microsoft.com/en-us/library/aa933068(SQL.80).aspx

Signature

Dave Sexton

> Hi everyone,
>
[quoted text clipped - 8 lines]
> The table will have approximately 300-500 rows and about 7 fields in
> each row.

Reply to this Message

Caching an sql table

Free Magazines