Internet Marketing Forum

For Webmasters and Entrepreneurs

Welcome, Guest. Please login or register.
Did you miss your activation email?
May 21, 2012, 02:54:34 PM

We judge ourselves by what we feel capable of doing, while others judge us by what we have already done.

- Longfellow

Home

Privacy

Internet Marketing Forum > Online Business Discussions > Website Design and Maintenance > Database

How does mysql compare to other databases ?

0 Members and 1 Guest are viewing this topic.

Pages: [1]

Author

Topic: How does mysql compare to other databases ? (Read 1002 times)

BrunoBertoli

Beginner

Joined: Oct 2007
Posts: 33

$View BrunoBertoli\s Profile$
BrunoBertoli is from Italy

Italy

Nov 09, 2007, 07:03:24 AM

Hi all,

I'm wondering what some of the opinions are on mysql. I have read a lot of material (biased) by a lot of people and propaganda that obviously push one database over another. I have a great respect for the people and their opinions on this forum and thought I may ask for everyone's opinion here.

I personally never cared much for mysql because it always put an emphasis on speed and never focused on the "quality" or integrity of the data IMHO. I realize that mysql is trying to change that now by adding features such as triggers and sprocs.

I am in the middle of making a UI in php for a mysql db. This db requires transactions. I have used other databases in the past and have been dreading the point when I would have to implement transactions in this database.

After doing about 10 minutes of research, I found that as long as I am using Innodb, I am already set up for transactions and it defaults to "REPEATABLE READ"; I do not need to do anything else. Wow. I cannot believe that. Now that is simple indeed.

I remember using transactions in postgres about 5 or 6 years ago and it was a pain from a programming standpoint. Mysql really has taken the pain out of using transactions. The ease of this database has really prompted me to ask around and see what everyone else thinks.

I have heard mysql referred to as a �toy database� and a �File system� on many occasions. Does anyone have any opinions on that?

Code4Gold

Administrator

Joined: Jan 2006
Posts: 6215

Administrator

$View Code4Gold\s Profile$

United States

Nov 09, 2007, 11:04:57 PM

I currently have a mysql database with over 100 million records in it and it is working flawlessly. Theone thing with any sql implementation is that you have to be aware of indexing and make sure you optimize and index your tables for optimum performance.

Latest Blog Post : 8 Tips for Creating a Marketing Buzz

Best Affiliate Programs Ξ SocialNews Ξ Blogger Forum Ξ Wealth Watching

GaryGyjax

Junior Member

Joined: Oct 2007
Posts: 55

$View GaryGyjax\s Profile$

United States

Dec 01, 2007, 01:23:18 PM

I love MySql. I have to use MS SQL server at work with ColdFusion and I think they stink compared to PHP and MySql. I'm running my websites on a linux hosting account so I had to make the switch and I've been very happy using these great free tools. Wolf

Free Ringtones Sign Language Books

Summer Savings! $7.49 .com domains at GoDaddy.com!

Pages: [1]