Subject Re: [firebird-support] Database for images
Author Alexandre Benson Smith
Leyne, Sean wrote:
> Aage,
>
>
>> Sean Leyne wrote:
>> <<
>> I would recommend page size of 32KB, which would be matched by a disk
>> cluster size of 32KB -- too truly maximize disk to memory transfer
>>
> speeds.
>
>> >>
>>
>> Is this possible? FlameRobin/0.7.6 doesn't offer more than 16KB.
>>
>
> Funny, IBExpert doesn't offer it either...
>
> I would have sworn that FB did 32KB pages --
>

And I have endorsed your comment, I was sure 32KB was supported. :-(

> Sean
>
>

But look ate this funny thing:

SQL> create database "localhost:c:\temp\teste.fdb" user "sysdba"
password "masterkey" page_size 32768;
SQL> show database;
Database: localhost:c:\temp\teste.fdb
Owner: SYSDBA
PAGE_SIZE 16384
Number of DB pages allocated = 135
Sweep interval = 20000
Forced Writes are ON
Transaction - oldest = 1
Transaction - oldest active = 2
Transaction - oldest snapshot = 2
Transaction - Next = 5
ODS = 11.0
Default Character set: NONE
SQL>

No error :-) Just assumed 16KB silently.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br