Is it ok to shrink the mcms database on a regular schedule? Will this action
affect any performance?

How to find out the page loading time for different internet speed?

My mcms database has 2250 nodes, most of my pages use outupt caching to
enchance the performance. Is it ok to set the Local Disk cache size to 3000M
B
and the nodes in Memory cache to 3000? I am not sure what value I should set
to optimize the performance.

Thanks

[ Post a follow-up to this message ]

Hi Mindy,

the number of nodes is not related to the disk cache size.
This only is related to the memory cache.
The amount of disk cache required depends on the size of the resource
gallery items in your database.

For database maintenance see the following article:
http://support.microsoft.com/?id=836646

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------


"Mindy" <Mindy@discussions.microsoft.com> wrote in message
news:C88F4D7D-9D42-4931-8219-6FA9623BA2F1@microsoft.com...
> Is it ok to shrink the mcms database on a regular schedule? Will this
> action
> affect any performance?
>
> How to find out the page loading time for different internet speed?
>
> My mcms database has 2250 nodes, most of my pages use outupt caching to
> enchance the performance. Is it ok to set the Local Disk cache size to
> 3000MB
> and the nodes in Memory cache to 3000? I am not sure what value I should
> set
> to optimize the performance.
>
> Thanks

[ Post a follow-up to this message ]

Thanks. One more question: how to find out the total size of the resource
gallery? What table of the resource gallery store in mcms db?
For Example, If the resource gallery is 50MB (images and PDF), then what
value should i set for the disk cache size?

"Stefan [MSFT]" wrote:

> Hi Mindy,
>
> the number of nodes is not related to the disk cache size.
> This only is related to the memory cache.
> The amount of disk cache required depends on the size of the resource
> gallery items in your database.
>
> For database maintenance see the following article:
> http://support.microsoft.com/?id=836646
>
> Cheers,
> Stefan
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> New to MCMS?
> Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44[/url...nyurl.com/8ugwj
> ----------------------
>
>
> "Mindy" <Mindy@discussions.microsoft.com> wrote in message
> news:C88F4D7D-9D42-4931-8219-6FA9623BA2F1@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

Hi Mindy,

the blobtable contains the resources.
The disk cache size needs to be bigger than the size of all resources. So if
50 MB are in the resource galleries you should set it to more than 50 MB.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------


"Mindy" <Mindy@discussions.microsoft.com> wrote in message
news:4BD75324-84DD-43BF-809C-72FC14F81EB7@microsoft.com...[vbcol=seagreen]
> Thanks. One more question: how to find out the total size of the resource
> gallery? What table of the resource gallery store in mcms db?
> For Example, If the resource gallery is 50MB (images and PDF), then what
> value should i set for the disk cache size?
>
> "Stefan [MSFT]" wrote:
> 

[ Post a follow-up to this message ]

Thanks for the quick response.

I run this sql: select sum(blobSize) from dbo.BlobTable; and it returns
108157418, and i am not sure if this number is in byte, or KB? Please advise
.

Thanks

"Stefan [MSFT]" wrote:

> Hi Mindy,
>
> the blobtable contains the resources.
> The disk cache size needs to be bigger than the size of all resources. So 
if
> 50 MB are in the resource galleries you should set it to more than 50 MB.
>
> Cheers,
> Stefan
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> New to MCMS?
> Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44[/url...nyurl.com/8ugwj
> ----------------------
>
>
> "Mindy" <Mindy@discussions.microsoft.com> wrote in message
> news:4BD75324-84DD-43BF-809C-72FC14F81EB7@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

Hi Mindy,

I assume this number is in bytes. So this would be 108 MB.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------


"Mindy" <Mindy@discussions.microsoft.com> wrote in message
news:3787D404-6B42-44DF-959D-F9EC5D60C2B9@microsoft.com...[vbcol=seagreen]
> Thanks for the quick response.
>
> I run this sql: select sum(blobSize) from dbo.BlobTable; and it returns
> 108157418, and i am not sure if this number is in byte, or KB? Please
> advise.
>
> Thanks
>
> "Stefan [MSFT]" wrote:
> 

[ Post a follow-up to this message ]