Subject | Re: [firebird-support] Database for images |
---|---|
Author | Alexandre Benson Smith |
Post date | 2007-05-09T21:05:57Z |
Leyne, Sean wrote:
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
> Aage,And I have endorsed your comment, I was sure 32KB was supported. :-(
>
>
>> 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 --
>
> SeanBut 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