Check out the SMF Function DB!
Started by [Unknown], September 20, 2005, 04:31:53 PM
Quote from: mark7144 on September 13, 2008, 07:21:59 AM...but when a match is on it can peak too 600+ users....
Quote from: poolhall on September 13, 2008, 03:10:35 PMQuote from: mark7144 on September 13, 2008, 07:21:59 AM...but when a match is on it can peak too 600+ users....Do you mean a soccer, football, boxing match, etc? If so, I would make an educated guess that the vast majority of visitors during the peak are viewing the same topic. Is it correct assumption? If it's the case, then InnoDB would not be beneficial for your because per the [Unknown]'s explanation given in the first post visitors will still have to wait for the topic table to become available.
Quote from: mark7144 on September 14, 2008, 06:32:05 AMI've also never seen less queries being used when upping the cache level in SMF so it seems useless to me.
Quote from: IQgeek on September 24, 2008, 12:57:19 PMShould I change to InnoDB?