--- In firebird-support@yahoogroups.com, "Werner F. Bruhin" <werner.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.
>
> I am pretty sure it has to do with my setup on Ubuntu - I am very NOOB
> on this.
>
> I installed FB 2.5-super using Synaptic and didn't tune anything.
>
> I am using Python/wxPython/sqlalchemy and the slow performance I see
> when I do bulk stuff, i.e. reading from a table check in another table
> if row exists and then either insert or update.
>
> I am aware that this is a very little information, but for the moment I
> am just looking for tips on what one should look at first before I dig
> in further down into the issue.
>
> Werner
>
> BTW, the db is just copied over from Windows - is this a no no? I.e.
> should I have to backup/restore instead?
>

Please try to do some more benchmarks with ext3 and xfs also
my idea why real hardware is not performing like virtual machine disk is that
Firebird writes page to the virtual drive , virtual drive driver caches it and is not doing a full fsync to the real disk and writing to the real disk happens in a queue that is not so agressive
like in the real machine where the writes are guaranteed
There are some regressions with the ext4 in some TPC benchmarks

Maybe i should try some benchmarks on partitions with ext2/3/4/btrfs/xfs/