5

What abilites have firebird to use it in highloaded projects? Whats better PostgreSQL or FireBirdSQL? Any one know big projects which work with Firebird database and developed over it?

tshepang
  • 12,111
  • 21
  • 91
  • 136
DefacedVR
  • 81
  • 4
  • 1
    Please specify what you mean with "big" or "highloaded": How many current users do you expect? What is the expected size of your DB? Every info you provide could be helpful. – Michael Nov 23 '11 at 15:24
  • In highloaded i mean above 100+ transaction per second per 1000 online clients. We expect that DB size will grow above 2gb per 3 month. – DefacedVR Nov 24 '11 at 07:13
  • You need to test your hardware performance too, it's not only about software. – Harriv Nov 24 '11 at 08:45

1 Answers1

10

Both Firebird and PostgreSQL are good choices. I think 'better' is highly subjective and not easy to answer for such a broad and unspecific question. The case-studies on firebirdsql.org lists some projects that might be of interest to you.

It is however important to keep in mind that performance in general depends largely on the way your system interacts with the database, transaction management (and transaction configuration), underlying server etc.

Full disclosure: I am a developer of the Firebird JDBC driver, so I may be biased :)

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
  • Yes, "better" is subjective. That was the point of the question. What are the values and advantages of Firebird over PostgreSQL? I've been searching – intgr Apr 18 '12 at 19:23