Microframe Corporation 3007 Series Uživatelská příručka stáhnout pdf (Strana 147)

1-139

6000 to 6050

The number of index segments that you may use depends on the

file’s page size.

See status codes 26: The number of keys specified is invalid and 29:

The key length is invalid for related information about index

segments and the transactional interface.

See also Choosing a Page Size and Segmentation in the Pervasive

PSQL Programmer's Guide, which is part of the Pervasive PSQL

Software Developer’s Kit (SDK).

6009: Index Name Duplicate

The index name is already being used a column. Use a unique index

name. See Naming Conventions in the online Pervasive PSQL

Page Size (bytes) Maximum Key Segments by File Version

8.x and prior 9.0 9.5

512 8 8 rounded up

1,024 23 23 97

1,536 24 24 rounded up

2,048 54 54 97

2,560 54 54 rounded up

3,072 54 54 rounded up

3,584 54 54 rounded up

4,096 119 119 119 or 204

8,192 n/a

119 119 or 420

16,384 n/a

n/a

119 or 420

”n/a” stands for “not applicable”

”rounded up” means that the page size is rounded up to the next size

supported by the file version. For example, 512 is rounded up to 1,024,

2,560 is rounded up to 4,096, and so forth.

The maximum number of index segments that can be used with the

relational interface is 119. For the transactional interface, the maximum

number is 204 for a page size of 4,096, and 420 for page sizes 8,192 and

16,384.

1 2 ... 142 143 144 145 146 147 148 149 150 151 152 ... 251 252

Žádné komentáře

Microframe Corporation 3007 Series Uživatelská příručka Strana 147