When is it appropriate to use InnoDB table types? What about for a forum such as this one with huge post and thread and memberlist tables? I was reading on dev.mysql.com that it is more efficient than MyISAM for large table types? Is this always the case? Would it make sense to mix and match MyISAM and InnoDB table types in my database based on the number of rows in the table?
Recommended Answers
Jump to PostI'm very interested in this answer, too. Hopefully some light will be shed on this thread.
Jump to PostAnd if what you describe is true, depending on the write frequency of a table, the row-level locking may be faster because additional updates are not waiting for the entire table to unlock. Sounds like reads would always be a tad slower? I don't know of course.
You should …
Jump to PostHere is some information about this: http://dev.mysql.com/doc/refman/5.0/en/table-locking.html
Thanks for the info and the link. The page at that link sells me on sticking with MyISAM I think.
Jump to Post*bump*
Very not long after my last post, DaniWeb moved to a dual server setup. And now, roughly one year later, it looks like we've been forced into going the InnoDB route. Surfing DaniWeb is speedy but posting has been hit or miss lately. Not sure if this …
Jump to Post*bump*
Very not long after my last post, DaniWeb moved to a dual server setup. And now, roughly one year later, it looks like we've been forced into going the InnoDB route. Surfing DaniWeb is speedy but posting has been hit or miss lately. Not sure if this …
All 30 Replies
Troy
35
Posting Whiz
Dani
2,366
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Troy
35
Posting Whiz
Dani
2,366
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Dani
2,366
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Troy
35
Posting Whiz
Dani
2,366
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Dani
2,366
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
Crirus
0
Newbie Poster
Stylish
1
Junior Poster
Dani
2,366
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
purefusion
0
Newbie Poster
anjama
0
Newbie Poster
Stylish
1
Junior Poster
anjama
0
Newbie Poster
Dani
2,366
The Queen of DaniWeb
Administrator
Featured Poster
Premium Member
jbcrawford
0
Newbie Poster
spirilis
0
Newbie Poster
cfry
0
Light Poster
chandranshu
0
Newbie Poster
mwasif
10
Posting Whiz
lizzeelike
0
Newbie Poster
salami1_1
0
Newbie Poster
Sword
0
Newbie Poster
markainsworth
0
Newbie Poster
ppetree
2
Junior Poster
bottomless
0
Newbie Poster
cardi777
0
Newbie Poster
Indurajput
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.