Anyway, looks like page size is not affecting the result too much: backing
up and restoring same database to 1024 and 16384 page sizes gives similar
times for the test.

time /opt/firebird/bin/isql -u SYSDBA -p masterkey /tmp/db16384.fdb -i
inputfile > output.txt

real 1m37.946s
user 0m0.143s
sys 0m0.223s

time /opt/firebird/bin/isql -u SYSDBA -p masterkey /tmp/db1024.fdb -i
inputfile > output.txt

real 1m38.239s
user 0m0.164s
sys 0m0.229s


-----Mensaje original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] En nombre de David Suárez
Enviado el: martes, 24 de enero de 2006 16:12
Para: firebird-support@yahoogroups.com
Asunto: RE: [firebird-support] Windows vs linux server performance

It was 4096 in both cases

SQL> show database;
Database: /data/testblob/01.fdb
Owner: SYSDBA
PAGE_SIZE 4096
Number of DB pages allocated = 19564
Sweep interval = 20000
Forced Writes are OFF
Transaction - oldest = 413433
Transaction - oldest active = 413434
Transaction - oldest snapshot = 413434
Transaction - Next = 413438
Default Character set: NONE
SQL>

-----Mensaje original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] En nombre de Steve Wiser
Enviado el: martes, 24 de enero de 2006 15:59
Para: firebird-support@yahoogroups.com
Asunto: Re: [firebird-support] Windows vs linux server performance

What is the page size?

-steve

David Suárez wrote:

> Hi all,
>
>
>
> Maybe somebody has experimented a similar behavoir and can bring some

light.

>
>
>
>
> While doing some tests with BLOBs, we found an interesting performance
> difference between linux and windows servers.
>
>
>
> Given a simple table with a primary key and a blob field:
>
>
>
> CREATE TABLE bindata (
>
> iobjid BIGINT NOT NULL,
>
> bdata BLOB sub_type 0 segment size 1);
>
> ALTER TABLE bindata ADD CONSTRAINT PK_bindata PRIMARY KEY (iobjid);
>
>
>
>
>
> This table has aprox. 18MB in blob data, splittted in 1100 records. Some
> records are 1MB, others just several hundreds bytes. We try to run isql
> utility to select this data locally in both linux and windows servers. In
> both cases, output.txt contains expected data
>
>
>
> time /opt/firebird/bin/isql -u SYSDBA -p masterkey /data/testblob/01.fdb

-i

> inputcommands.txt > output.txt
>
>
>
> Inputcommands.txt contains
>
>
>
> SET BLOB ALL;
>
> SELECT * FROM bindata;
>
>
>
> In linux (Fedora Core 4, local superserver 1.5.2 + libstdc++ 5 compat

rpms):

>
>
>
>
> real 1m37.937s
>
> user 0m0.144s
>
> sys 0m0.211s
>
>
>
> same test with windows local firebird server (1.5.2 superserver)
>
>
>
> elapsed-time: 2,651s
>
>
>
> both machines are xeon 3200 + 1GB ram
>
>
>
> Conclussion: 2,6 windows vs 97,9 linux. Anybody has found something

similar?

> I believe there must be some configuration issue in the linux side, as the
> problems also show up inserting blob contents.
>
>
>
> Kind regards
>
>
>
> David
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links









++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links