FROM SQL to FIREBIRD

[daemon]

I have suggestion to move from mysql to Firebird. Mysql is for another purposes and its good only for select queries. Firebird embedded server is 100 times better than mysql and i think it will increase server stability on high people population (3k-4k). I think this topic should be discussed

[Aikimaniac]

Is your idea based on real tests in L2J environment ?

[daemon]

yes, firebird embedded server is now on asterios.tm servers

[jurchiks]

Well, that's not really l2j anymore, they use l2p which was forked from l2j and has been pretty much standalone for many years now.
Comparison between l2j and l2p would be problematic.

[Aikimaniac]

yes, firebird embedded server is now on asterios.tm servers

well..can you post some performance tests with mysql and same tests with firebird ?

[ir00]

Yeah please do some tests.
What i'v found

You can find some of them online, I once tried to migrate Firebird's standard "employee.fdb" database to MySQL and wrote a few notes about it, see my blog.
See part 1 part 2 part 3 part 4 part 5 part 6 part 7 part 8.
Note that I used Firebird 2.0, while the current release is firebird 2.1 which has had some improvements and the upcoming Firebird 2.5 will be even better!
My opinion is that, as a classical database (no fulltext, no ndb clustering, partial replication) Firebird is more robust and consistent.
As an embedded database it is probably the best in the market (again, just my opinion).

[momo61]

wow, very very interesting :s

Im reading about Firebird right now, and it's supposed to be a lot better than MySQL.
Even MySQL is supposedly moving in the direction of Firebird...

http://www.youtube.com/watch?v=vAHZjOLmu1g

[ThePhoenixBird]

What about PostgreSQL?

[MELERIX]

there is a topic related with this: viewtopic.php?f=69&t=20264

anyway I think is not needed, MySQL is enough, and MySQL 5.5.x is more fast than older versions.