Welcome, Guest. Please login or register.
Did you miss your activation email?
Jan 06, 2009, 05:29:15 PM

Motivation is everything. You can do the work of two people, but you can't be two people. Instead, you have to inspire the next guy down the line and get him to inspire his people.

- Lee Iacocca

Home

Help

Welcome Guest - Register or Login Now to remove these advertisments

Registration is completely free and only takes a few minutes to signup !

Entrepreneur Forum > Webmasters - Discuss Making Money Online > 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 402 times)

BrunoBertoli

New Member

Joined: Oct 2007
Posts: 30

$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?

~Dave~

Administrator

Joined: Jan 2006
Posts: 6186

Building a Foundation

$View ~Dave~\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 : Social Media Optimization for Social Media Marketing

Best Affiliate Programs Îž Blogging News Îž Blogger Forum Îž Credit Card Help

GaryGyjax

New Member

Joined: Oct 2007
Posts: 48

$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

Pages: [1]