>>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.

>A table scan over the net will take a while. Try being more specific with your SQL if possible.
Try not to use the *

I was comparing the speed of Firebird 2.1 with that of SQL Server 2005, Mysql 5.1 and Postgre 8.3. I have not yet implemented it in my application, because I have serious doubts about the performance of Firebird with anything more than 8000-10000 rows in a table.

Is the performance of Firebird very slow as compared to other databases?