If I remember correctly SQL Anywhere provides a method to calibrate the real local IO speed, so that the optimizer is not using anymore the 40x speed assumption for sequential reads compared to random reads of the database files.

Does anyone know more details?

e.g. is the calibration time dependent on the database size?

asked 13 Dec '10, 15:33

Martin's gravatar image

Martin
8.6k116150237
accept rate: 14%

edited 14 Dec '10, 08:17


I guess you are refering to the ALTER DATABASE CALIBRATE statements:

-- Syntax 2 - Performing calibration
ALTER DATABASE {
 CALIBRATE [ SERVER ]
 | CALIBRATE DBSPACE dbspace-name
 | CALIBRATE DBSPACE TEMPORARY
 | CALIBRATE GROUP READ
 | CALIBRATE PARALLEL READ
 | RESTORE DEFAULT CALIBRATION

No, I don't know more details...

permanent link

answered 13 Dec '10, 16:12

Volker%20Barth's gravatar image

Volker Barth
30.3k300452659
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×242
×27

question asked: 13 Dec '10, 15:33

question was seen: 1,017 times

last updated: 14 Dec '10, 08:17