|
Take a look at my answer to a similar question that asked about what NTFS allocation size should be used for an 8k database page size. Short answer is that it doesn't really matter if you are not that concerned about getting optimal performance. If you want best performance and best probability that your file system is not going to corrupt your database file then it is likely best to match your page size to the file system page size (and natural disk sector size).... but you need to be careful if your file system sector size is too large (16K or 32K) since other effects can kick in - e.g. wasted cache memory due to using a page size which is too large for your database schema and application usage pattern. I.e. if your file system sector size is 16K or 32K then I would suggest that you do a performance evaluation between using a 16K (or 32K) database page size and an 8k (and/or 4K) page size. Thanks, I did see and read that answer after posting! Now I need to do some leg work to see what DB page size is ideal for my case then select an appropriate cluster size from that.
(22 Jul '11, 09:57)
ivankb
|
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 22 Jul '11, 09:05
question was seen: 6,947 times
last updated: 22 Jul '11, 16:31