decisions, decisions????

He has: 4 posts

Joined: Apr 2007

I am in a bit of a quandry as to which database to use. I will need several functions...
log in, registration, organization to fill out imformation form containing a fair amount of information, this information will need to be returned in a "report". membership information, facility review reports, a few others odds and ends...
I am told MySQL will work but is slower than some other choices...true?

JeevesBond's picture

He has: 3,956 posts

Joined: Jun 2002

delee36 wrote: I am told MySQL will work but is slower than some other choices

Who told you that? By my reckoning, if MySQL is good enough for Slashdot, Digg, Wikipedia, The Webmaster Forums (us) and aPaddedCell (also us, had to get them in the list) then it's probably good enough for you. Noting that those are probably some of the highest traffic sites on the Web (apart from ours, sadly).

Did this person list the alternatives?

For proof see: http://www.innodb.com/userstories.php InnoDB is a storage engine for MySQL. For Digg you'll just have to trust me, I saw they were using MySQL in their 'sorry our site's down for maintenance' page, we'd need to wait for that to appear again to prove it. Smiling

a Padded Cell our articles site!

He has: 6 posts

Joined: May 2007

MySQL is fast, faster than most database engines.. There is also sqlite which is an embedded database library with support for transactions, which is faster than mysql. Just a little difficult to administer than mysql, imho, anyways.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.