Firebird and database sizes

I searched a whole day the internet to get some results on how firebird handles larde databases like 10G and is there some significant drowbacks in performance.

I am trying to find the actual limits of one firebird db.

I will highly appreciate if you share your experiense with firebird. Include how big was the DB, how many record in the tables (max, average ...) and performance ( query speed, concurent work). Yes is will be also interesting to see how FB copes with lots of users at the same time.

Thanks in advance,
Stiff

I did some benchmarks using JMeter and dbmonster (for a different purpose, I was testing speed of encrypted tunnels and doing a comparison with MySQL) and it was not so bad (a bit slower than MySQL but more stable performance), you can do the same.

I have tested with something like 50000 rows and some JOINS but i need to know how FB handles something like 10GB databases.

We are trying to make the right decision whether we shall pay the money for MS SQL to be sure that it can handle large DBs or to trust Firebird. I need some real productoin experiense.

You can read some experiences (1, 2, 3) but I would anyway do a stress test with my own app.

This is exactly what I needed.

My main problem is that I must make a desicion wheather to use Firebird for a Project with expected DB size of about 10GB, and I cannot make a stress test because I don't have the app yet. But now I think I will use it because I hate MS SQL for binding me with Windows Servers witch costs too much to use it only as a dedicated DB server. Plus it is not very appealing to customers to pay something like 5000$ just for the Database and the Windows Server, when you can give them FB+Linux for free and they will never stop working.

Hi,
We used MSSQL 2000 and with database size ~7Gb it will die when you have more than 20-30 concurrent users. So I have evaluated many RDBMS, including Oracle9i, DB2... But after all testing, we decided to go Firebird route.
Right now, db is larger than 23Gb... And it works great! We haven't noticed some serious slowdown at this size. Just optimize your queries and performance is there... And with carefull choice of indices, of course

--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
USAID TAMP Senior Programmer
FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
JEDI VCS contributor
http://jedivcs.sourceforge.net/

thenks a lot, I will put my trust on FB.