database type....
Moderator: General Moderators
database type....
Hey everyone.!
if I am working on putting together a highly transactional site, similar to a facebook..;
what is the correct type of database I should use? (myisam, innodb)
also are there any other considerations I should think about???
Thanks a lot!!
ANdrew
if I am working on putting together a highly transactional site, similar to a facebook..;
what is the correct type of database I should use? (myisam, innodb)
also are there any other considerations I should think about???
Thanks a lot!!
ANdrew
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
The main considerations are whether you will do mainly reads or writes on the table, and whether you need transactions. Traditionally tables that do record locking have better write performance, whereas tables that do table locking have better read performance. But there are many exceptions to that. The manual goes through the tradeoffs.
(#10850)
You're probably going to have more reads than writes, so MyISAM is probably best. But, as ~Inkyskin & I have just demonstrated, you're going to get mixed answer to this question.
There are some useful reviews of MyISAM vs. InnoDB found via Google.
There are some useful reviews of MyISAM vs. InnoDB found via Google.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
Foreign keys aren't really necessary. You get more control at an application-level if you check there, and you can build error messages and such accordingly. arborint already touched on the row locking versus table locking, but if you're really curious, look in the MySQL manual. It has a good amount of resources on the different types on databases and the advantages / disadvantages of either.
If you're looking for a definite "this one is better," you're likely not going to find it. Just be the judge of what you're after, since you probably know your idea more than any of us could.
If you're looking for a definite "this one is better," you're likely not going to find it. Just be the judge of what you're after, since you probably know your idea more than any of us could.
Not sure on this but can you have a mix of table types in a database?
So innoDB for those that need transactional queries and myisam if you don't?
I've been reading about the 2 types recently as i've always used myisam, so it's a question in relation to the topic that might help the original poster when answered.
So innoDB for those that need transactional queries and myisam if you don't?
I've been reading about the 2 types recently as i've always used myisam, so it's a question in relation to the topic that might help the original poster when answered.
- Kieran Huggins
- DevNet Master
- Posts: 3635
- Joined: Wed Dec 06, 2006 4:14 pm
- Location: Toronto, Canada
- Contact: