Quite frankly you seem clueless on this, so let me spell it out for you again.
No mysql server, ever, should take 6 hours to run a table alter on a 1.5 million row table. Any that does is very badly broken or configured, and any "expert" who tells you otherwise is either lying through their teeth or has no idea what they are doing, and yes, I will very much argue the point.
I can run an alter on a 2.2 million row node table (Innodb as well, which takes longer) in about 30 minutes on my home PC, let alone a dedicated server (I did so yesterday, twice).
I have no intention of ever installing dbtech plugins on any site, for totally unrelated reasons.
Paul, as long as you're not installing DB's plugin on a big forum and show us the result, than you can't backup what you just said.
I too can't ignore an expert server admin known among many companies and listen to you unless you show me proves.
Quote:
Originally Posted by DragonByte Tech
Would you say that it is better to spend 6+ hours on a "finalise" action to import all your members into a different "user" table?
Would you say that it is better to leave your forum running gradually slower and slower due to multiple queries needed to fetch all the information, compared to a one-time slowdown when installing the product?
We don't create table alterations because we enjoy hearing complaints from large forums. We created them because it is the best option when considering the performance of your forum.
Fillip
How are you disputing Fillip's comment Paul, i think he knows more what his plugin does for big communities. He never refute it.
05-21-2014, 07:47 PM
Threaded Mode