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