Page 1 of 1
FROM SQL to FIREBIRD
Posted: Wed Apr 20, 2011 6:53 am
by 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
Re: FROM SQL to FIREBIRD
Posted: Wed Apr 20, 2011 8:51 am
by Aikimaniac
Is your idea based on real tests in L2J environment ?
Re: FROM SQL to FIREBIRD
Posted: Wed Apr 20, 2011 1:12 pm
by daemon
yes, firebird embedded server is now on asterios.tm servers
Re: FROM SQL to FIREBIRD
Posted: Wed Apr 20, 2011 1:32 pm
by 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.
Re: FROM SQL to FIREBIRD
Posted: Wed Apr 20, 2011 2:09 pm
by Aikimaniac
daemon wrote:yes, firebird embedded server is now on asterios.tm servers
well..can you post some performance tests with mysql and same tests with firebird ?
Re: FROM SQL to FIREBIRD
Posted: Wed Apr 20, 2011 6:00 pm
by 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).
Re: FROM SQL to FIREBIRD
Posted: Wed Apr 20, 2011 8:26 pm
by 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
Re: FROM SQL to FIREBIRD
Posted: Thu Apr 21, 2011 12:19 am
by ThePhoenixBird
What about PostgreSQL?
Re: FROM SQL to FIREBIRD
Posted: Thu Apr 21, 2011 2:20 am
by 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.