UNIX and Linux Applications

Thank you for choosing this thread to read.

I am about to develop a heavy set financial system. My client wants to build his own in-house. Due to my LAMP/BSD mind set, I know MySQL, but no other database (never got the chance to see others). I do not know if MySQL can handle 2000 to 5000 records entries per day, and keep these records for years to come to be used, sometimes frequently.

I heard, and read on line plenty of good words about Oracle, and Sybase.

If you have worked with MySQL, and any other DB engine, like Oracle, or Sybase, How do you compare performance, and which one would you recommend for a heavy set financial system?

Your personal experience gestures here is really appreciated.

Thank you for reading, and for your reply in advance.

If am wrong or misunderstood just correct me.

2K to 5K per day translates to just 730K to 1825K which should be an easy piece of cake for any db to handle.

I had worked with Informix giant version(s) where it would handle 1800 M / month without any hassle or throttling / performance issues.

But again it depends on the version that you are going to use.

We need more information to sort out this.

When these are system software / feasibility issues,
Updations / insertions through code also need to be considered.

agree with matrixmadhan, numbers you are refering to are not into the extreme. Shouldn't be a problem at all. MySQL you can store in several storage engines with their own advantages.
You can of course spend a lot of money on Oracle, Sybase or DB2 (or whatever) but when you have your own development you can make your own choice. Maybe it is wise to have some support but MySQL can provide that for you (or is it SUN now...)

If I had the choice I would first look at the opensource alternatives and if they do not work for you look at the comercial options, but that's just me..

Greetings and salutation,
market research is it? I've been an Oracle DBA on unix for a long time, like it just fine, can handle the small workload you're talking about without issues, can run on many platforms / OS's. Terabyte to petabyte not an issue - to the database anyway

The real issues are supportability over the long run, any of the commercially available rdbms engines will do what you want, if it's storing data and being able to retrieve it. I've got friends running DB2, Informix, Sybase and Oracle in the same shop. MySql is very popular because of the cost and it's features compare favoriably with any of the commercially available RDBMS's I've been told.

If Sarbanes-Oxley compliance is a requirement make sure you research how much work it would be to meet that requirement with the features available. It used to be easier to pick an RDBMS, you looked at what would run on your OS(s), then features, then price. By the time you got done with that you had only one or two choices. Now the products are so close, it's very difficult.

As stated up front, I'm an Oracle DBA, so I would recommend that, however, that could be from lack of current knowledge of the product offerings from the other vendors. I've managed databases in the terabyte range and with Oracle it was easy, not saying it wouldn't have been just as easy with another product, just it's more a matter of familiarity. It used to be Oracle DBA's were very expensive, now with the availability of remote on demand administration and monitoring, the costs have come down. Take as much time as you can to research and find out what best fits your needs, because, while picking a rdbms is difficult, migrating from one rdbms to another is much more difficult and time consuming.

Hope this is of some help. If you have questions ask.