Paul Beach wrote:

>>But what I just need to know that the BLOB data captured under the 4096
>>will not be affected by the 1024 settings accessing them ??
>>
>>I believe I am worrying to much and that the database has been restored ALL through
>>with the 1024 size . But I need to confirm.
>>
>>
>
>You are worrying too much - the blobs restored under a page size of 1024 will
>work exactly the same way as when the page size was 4096. My comment is that you
>are likely to find performance better at 4096, than at 1024.
>
>
>

Is there ever a case for using a higher value? What would be the effect?

Thanks!

Jonathan Neve.


[Non-text portions of this message have been removed]