On 05/13/2011 04:49 PM, Werner F. Bruhin wrote:

> Paul,
>
> On 05/13/2011 02:18 PM, Mercea Paul wrote:
>> On 2011.05.11 4:38 PM, Werner F. Bruhin wrote:
>>> I am trying out Ubuntu and not that FB is a lot slower on it compared to
>>> Win 7. I am running this on the same hardware by dual booting and
>>> actually running FB 2.5 in a Win 7 VM under Ubuntu is just about as fast
>>> as in native Win 7.
>>> .................
>>>
>>> BTW, the db is just copied over from Windows - is this a no no? I.e.
>>> should I have to backup/restore instead?
>>>
>>>
>> Hi Werner
>> I would make a back-up with "portable format" checked!
>> After that a restore on ubuntu.
>>
>> Give it a try!
>>
> Did and it is a bit better but still far off:
>
> After restore using portable formate:
> 52.14 sec
>
> compared to my initial test results:
> On Ubuntu it takes: 95.6 sec
> On Windows 7 VM as guest on Ubunto 10.10 it takes: 12.1 sec
> On Windows 7 native on same machine (Intel i5 with 4 GB) it takes: 18.6 sec
>
> Werner
>
> P.S.
> db properties as shown by FlameRobin:
> twcb
> localhost:/home/wbruhin/devProjects/twcb/data/twcb.fdb
> Database file ODS Version 11.2
> Page size 8192
> Pages 1459
> Size on disk 11.40MB
> Page buffers 2048
> Read only false
>
> Settings
> Dialect 3
> Default character set UTF8
> Sweep interval 20000
> Forced writes true
>
>

I did some more searching:
- Helen's book - chapter 36 configuration
- http://www.firebirdsql.org/manual/ubusetup.html
- http://www.firebirdsql.org/index.php?op=useful - also a lot seems to
be a bit out dated
- google search "firebird performance tuning"

Tried following settings in /etc/firebird/2.5/firebird.conf :
- set - DefaultDbCachPages = 10000
- set - TempDirectories = /media/MyBookAVI/fbtemp;/tmp

After changes restarted server with "sudo /etc/init.d/firebird2.5-super
restart"

But I don't see a significant change, i.e. it is still above 50 seconds
compared to 10 to 20 seconds on Windows.

Is there really nothing one can do?

Werner