I will be Back - Vbseo

[katie hunter]

Originally Posted by Paul M

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.

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.

[tpearl5]

I'd be curious to see the output of mysqltuner...

[DragonByte Tech]

Originally Posted by katie hunter

How are you disputing Fillip's comment Paul, i think he knows more what his plugin does for big communities. He never refute it.

Please do not put words in my mouth. Nothing in my comment goes against what Paul said, he and everyone else you have discussed this issue with is 100% correct.

If your server spends 6+ hours on those alters, then it would likely also spend 6 hours inserting 1.5 million rows in another table due to the serious misconfiguration on your server. That is all I said, and that is all I intended to say.

Any of the people who have argued with you on this issue could reconfigure your server to perform vastly better, that is a fact.


Fillip

[wjkingsnorth]

vBSEO cause hostgator to shut down my vb forum. Never will use it this time around.

[final kaoss]

Originally Posted by wjkingsnorth

vBSEO cause hostgator to shut down my vb forum. Never will use it this time around.

Ah hostgator... I remember leaving them for this very issue, there's quite a few other complaints from customers using vbseo on their forums as well.

I've moved on to flipperhost for a couple of years now and their vps plans are worth looking into.
http://flipperhost.com/

[katie hunter]

Originally Posted by DragonByte Tech

Please do not put words in my mouth. Nothing in my comment goes against what Paul said, he and everyone else you have discussed this issue with is 100% correct.

If your server spends 6+ hours on those alters, then it would likely also spend 6 hours inserting 1.5 million rows in another table due to the serious misconfiguration on your server. That is all I said, and that is all I intended to say.

Any of the people who have argued with you on this issue could reconfigure your server to perform vastly better, that is a fact.


Fillip

Fillip, I've quoted what you said on page 1, you said exactly this

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.

All those who came in here saying I have a Mysql issues, haven't showed me a different result, they can install any of DB's plugins on a big vb community and share the result but they don't want to do it, so their statements holds no value other than seeing he say she say type of statements that gets no where.

I've installed 2 or 3 of DB's plugins in the past and i had to uninstall all of them and each time i had to wait that long to get rid of them or install them. None of the other plugins i installed did this and I've been with VB since 2006 and always tried different kind of plugins. You relay heavily on altering VB database which in my opinion is bad.. for big communities at least.

You didn't deny that your plugin could do that on page 1 or else you could have said something like i have clients who have big communities and they never run to similar issues similar to yours but what you said is this

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?

Many people here wants to prove their point to be right, well you're not going to prove it unless you try it and share the result. So try it! those who claim i might have a mysql issue, try installing DB's plugin, any one on big communities and see how long it will take to import the xml product.

Try installing this plugin as a test on a popular vb community with millions of posts, threads and members and see how long it will take https://vborg.vbsupport.ru/showthread.php?t=242733 I tried fiew others and same issue i had, 6+ hours to import or uninstall.

Tried these as well (after that, i decided that i can't risk installing any of DB's plugins)
https://vborg.vbsupport.ru/showthread.php?t=236980
https://vborg.vbsupport.ru/showthread.php?t=287053
https://vborg.vbsupport.ru/showthread.php?t=298471

[Paul M]

Originally Posted by katie hunter

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.

If you are daft enough to believe either of these statements than there is no hope for you. :erm:

Everyone else can see the issue, just not you. Feel free to stick your head in the sand and continue to suffer a badly configured server, not my issue so I really dont care.

[katie hunter]

Originally Posted by Paul M

If you are daft enough to believe either of these statements than there is no hope for you. :erm:

Everyone else can see the issue, just not you. Feel free to stick your head in the sand and continue to suffer a badly configured server, not my issue so I really dont care.

No, I don't see any issue. I will be happy to send you my server admin company name and you can take that argument on http://www.webhostingtalk.com trying to prove that you know how to optimize Mysql more than he does, trust me, it won't be pretty =)

You really don't know what you're talking about unless you prove your point by showing the result, you don't want to do it, then don't try to prove anything. If you want to show your point, prove it.

Try installing this plugin as a test on a popular vb community with millions of posts, threads and members and see how long it will take https://vborg.vbsupport.ru/showthread.php?t=242733 I tried fiew others and same issue i had, 6+ hours to import or uninstall.

[final kaoss]

Originally Posted by Zachery

ANY alter is going to lock the table, that bit is unavoidable. however, how long it stays locked for is another point all together. 6 hours for 1.5 million rows seems excessive.

This is the point that keeps being overlooked and there's your proof right there. Why don't you try another product that locks tables and see how long it takes, chances are it's going to take just as long. And in that case, there's your proof that it's not just DBTech's mods that are giving you issues but it's your very own server.

[katie hunter]

Originally Posted by final kaoss

This is the point that keeps being overlooked and there's your proof right there.

Yes that is what happen and the lock stays very short time, but like i said many changes after each lock happens.

You will just have to try installing DB's plugin on popular forum communities to find out.

Originally Posted by final kaoss

Why don't you try another product that locks tables and see how long it takes, chances are it's going to take just as long. And in that case, there's your proof that it's not just DBTech's mods that are giving you issues but it's your very own server.

These mods i have, it says it contain DB changes, i never see any locks or that it takes that long, mere seconds to install ( I can keep going with the list of mods i have installed = no issues )
https://vborg.vbsupport.ru/showthread.php?t=248042
https://vborg.vbsupport.ru/showthread.php?t=123415
https://vborg.vbsupport.ru/showthread.php?t=251408
https://vborg.vbsupport.ru/showthread.php?p=2325589

The issue with DB's plugin is that it affects and alter profiles, thousand of members. Few small alters is nothing compare to thousands and millions.