>I have created a table with 10000 records in Firebird and a simple select * is slow. Over network @ 100 Mbps it takes a long time to fetch 10000 rows. The same is a snap in SQL Server or Mysql and only slightly slower in Postgre.
>
>Am I doing something wrong? I didn't change any settings after Firebird installation.

Hi. If is a multiprocessor / multicore server, check and modify CpuAffinityMask in firebird.conf
Or use clasic server.

Check database file fragmentation too, this can be another cause.

We use Firebird and is not slow at all.

HTH