SAP SQL Anywhere

Question

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?

Accepted Answer

1

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 Barth
40.2k●361●550●822
accept rate: 34%

flat view

SAP SQL Anywhere

How to calibrate the IO read speed for the query optimizer?

Follow this question

Related questions