Recent

Author Topic: TurboBird needs new owner  (Read 15602 times)

motaz

  • Sr. Member
  • ****
  • Posts: 495
    • http://code.sd
TurboBird needs new owner
« on: August 08, 2015, 11:04:16 am »
I have started development of TurboBird in 2009, and since long time I didn't add any important feature to it. Lately BigChimp has helped this project by making huge internal redesign and adding new features.

Due to my starting of my own software development company I didn't find any time to return to this project, specially that I moved to MySQL instead of FireBird. MySQL has a good solution for master/slave redundancy and has ability to work with huge data.

http://code.sd/products/turbobird/

If anyone want to take the ownership of development of this project it will be more than welcome. It is available in GitHub:
https://github.com/motaz/turbobird

aradeonas

  • Hero Member
  • *****
  • Posts: 824
Re: TurboBird needs new owner
« Reply #1 on: August 08, 2015, 11:12:16 am »
Quote
I moved to MySQL instead of FireBird. MySQL has a good solution for master/slave redundancy and has ability to work with huge data.
Because you have exprence I want to ask why you moved to MySQL? FireBird clame that it can work with huge data and its very ligh.

motaz

  • Sr. Member
  • ****
  • Posts: 495
    • http://code.sd
Re: TurboBird needs new owner
« Reply #2 on: August 08, 2015, 12:00:07 pm »
I have a system that contains two databases, MySQL and Firebird. MySQL table reaches about 50 Million record and it works fine, but Firebird becomes very slow and hang the system up when the table reaches hundreds of thousands of records, also I noticed that it consumes more CPU than MySQL.

In one case I found that Firebird did not use a secondary index to speed up the query. In a query that needs to return 20 records it takes about minute to execute because it contains descending order, when I turn it to ascending it takes seconds, I have created descending index, but I get the same delay.

The most important feature is the on-line master/slave redundancy which exist natively in MySQL. We are relying on slave database to generate reports and to make full backup, to keep master database busy with important tasks.

Actually I'm using MariaDB but it is the same like MySQL.
Another factor is that MariaDB/MySQL is used by large web sites such as wikipedia, and Twitter. Customers tend to ask us what database you are using, second question is what language. Third (optional) question is what operating system in the server side.
« Last Edit: August 08, 2015, 12:23:30 pm by motaz »

aradeonas

  • Hero Member
  • *****
  • Posts: 824
Re: TurboBird needs new owner
« Reply #3 on: August 08, 2015, 12:47:17 pm »
Quote
50 Million record
Its weird that Firebird have problem with this count of record!

motaz

  • Sr. Member
  • ****
  • Posts: 495
    • http://code.sd
Re: TurboBird needs new owner
« Reply #4 on: August 08, 2015, 12:56:40 pm »
Quote
Quote

    50 Million record

Its weird that Firebird have problem with this count of record!

This for MySQL, with Firebird I haven't reach one million of records yet. After yesterday system stop   because of Firebird, I was thinking to migrate my SMS gateway software from Firebird to MySQL

aradeonas

  • Hero Member
  • *****
  • Posts: 824
Re: TurboBird needs new owner
« Reply #5 on: August 08, 2015, 01:05:50 pm »
Sad!

marcov

  • Administrator
  • Hero Member
  • *
  • Posts: 11383
  • FPC developer.
Re: TurboBird needs new owner
« Reply #6 on: August 08, 2015, 01:20:48 pm »
Both run in the same transactional mode? Either both with full transaction support or effectively dumb storage ?

motaz

  • Sr. Member
  • ****
  • Posts: 495
    • http://code.sd
Re: TurboBird needs new owner
« Reply #7 on: August 08, 2015, 02:06:40 pm »
They are different databases systems, but at least I have never encounter the same problem with descending index data retrieval in MySQL.
I think it is a bug in FireBird that prevent it to not use the index in certain case.

Graeme

  • Hero Member
  • *****
  • Posts: 1428
    • Graeme on the web
Re: TurboBird needs new owner
« Reply #8 on: August 10, 2015, 11:15:35 am »
Quote
Quote
Its weird that Firebird have problem with this count of record!
Indeed, it must be a table, or index setup issue. Or maybe the client doing the performance test. I have 10's of millions of records in various Firebird database, all a couple GB of data, and they all work perfectly and very fast. I know of other companies that have the exact same experience as I.

So I definitely don't see it as a general Firebird issue, but a localised issue in Motaz's setup.
--
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://fpgui.sourceforge.net/

aradeonas

  • Hero Member
  • *****
  • Posts: 824
Re: TurboBird needs new owner
« Reply #9 on: August 10, 2015, 11:17:55 am »
Graeme are you satisfied with Firebird against MySQL?
I had experienced with it and it look promising beside the lack of tools but how is it in real jobs?

Groffy

  • Full Member
  • ***
  • Posts: 204
Re: TurboBird needs new owner
« Reply #10 on: August 10, 2015, 12:08:36 pm »
@aradeonas

Which db-engine do you use with MariaDB? Aria? (=MyIsam+) You can't really compare this with Firebird. Its not transactional, it has no referencial integrity. I would agree with Graeme that there might be a configuration / index design problem.


Linux Mint / Windows 10 / Lazarus 3.0.0 / trunk -qt

aradeonas

  • Hero Member
  • *****
  • Posts: 824
Re: TurboBird needs new owner
« Reply #11 on: August 10, 2015, 12:39:27 pm »
No im not against Firebird,I like it but I want to hear about experience in real job from someone like Graeme .

motaz

  • Sr. Member
  • ****
  • Posts: 495
    • http://code.sd
Re: TurboBird needs new owner
« Reply #12 on: August 10, 2015, 02:45:21 pm »
@Groffy
Quote
Which db-engine do you use with MariaDB? Aria? (=MyIsam+) You can't really compare this with Firebird. Its not transactional, it has no referencial integrity. I would agree with Graeme that there might be a configuration / index design problem.

I'm using innoDB

I'll not do migration for SMS Gateway database and I'll keep it with Firebird to get more experience with it, and I'll try to find the solution from inside Firebird instead of leaving it to MySQL.
MySQL also is not the complete solution, it has licensing issues.

Graeme

  • Hero Member
  • *****
  • Posts: 1428
    • Graeme on the web
Re: TurboBird needs new owner
« Reply #13 on: August 11, 2015, 12:48:10 pm »
Graeme are you satisfied with Firebird against MySQL?
I had experienced with it and it look promising beside the lack of tools but how is it in real jobs?
Yes, I'm very satisfied with Firebird. Also development in Firebird is going at a good place and stable releases are supported for a long time - great news if you have many clients and deployments. The upcoming Firebird Server v3.0 also has some very nice features included.

Out of the box, Firebird performs very well. I also like the fact that the database is a single file (configurable to have more) and is not affected by the file system you use (an issue with MySQL and MariaDB). Firebird also packs a huge punch for its size. It is very small, yet supports so many features. I use it for small single person database up to large scale systems where the databases are in the multi gigabyte size. I've also read multiple case studies where they have Firebird databases in the terabyte range. I haven't reached that yet. ;-)

Firebird also supports read-only database and can be deployed as an embedded database (no database server process needed). It is just such a flexible product!

As for tools... there are stacks of them available. From open source to commercial ones. Many start of with FlameRobin - a very nice open source database management application. Later, if the need arises, you can switch or add other commercial tools that do more advanced things like profiling, advanced tracing etc. There is also commercial support available from various companies if you need that.
--
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://fpgui.sourceforge.net/

motaz

  • Sr. Member
  • ****
  • Posts: 495
    • http://code.sd
Re: TurboBird needs new owner
« Reply #14 on: August 11, 2015, 12:55:19 pm »
@Graeme
Did you use on-line master/slave database replication in Firebird ?

 

TinyPortal © 2005-2018