I will be Back - Vbseo

[ForceHSS]

I will stay with dbseo for me there support and plugins are better by far. Just look how vbseo treated its members after closing this alone tells you what type of people runs it

[katie hunter]

Originally Posted by Zachery

If the table alters are causing that much of a problem, you should probably bring that up.

I did report it several times in some of his other plugins, as you see Fillip below didn't deny it. I don't really like when plugins and addon alter VB database.

@Fillip like i said i will give your plugin a try for a new project since it won't have that many registered members at its start. At least i can try it without causing my tables to get locked.

But something to consider with all your plugins, big sites would use it if you don't relay on heavily altering the database of VB. Having your site down for 6+ hours isn't really a fun a experience when installing or uninstalling a plugin. Not to mention worrying if your tables gets damages during the process for whatever odd reason.

Originally Posted by ForceHSS

I will stay with dbseo for me there support and plugins are better by far. Just look how vbseo treated its members after closing this alone tells you what type of people runs it

They didn't treat their members bad, their staff just broke down in disagreement and partially it involved a family dispute. This can happen with any company if it doesn't have strong backbone.

[Zachery]

Your site shouldn't be down that long, to begin with. I suspect your MySQL servers aren't up to snuff.

[katie hunter]

Originally Posted by Zachery

Your site shouldn't be down that long, to begin with. I suspect your MySQL servers aren't up to snuff.

We have the best server admin known on http://www.webhostingtalk.com So that much I know. If he could do anything, he would have done it. You'd be lucky actually if you can hire him now days because he is so busy, he doesn't take new clients easily. If you visit WHT, you will probably notice his name being mentioned all the time.

You can't do anything when your tables are being altered and gets locked multiple time due to the heavy process and we run on strong dedicated server. The issue is altering thousands of tables at once.

[Zachery]

Your vBulletin database has thousands of tables? Did you mean thousands of rows.

I stand by what I said, if your db isn't doing alters quickly, something is wrong. Either bad MySQL performance, or bad hardware performance.

[katie hunter]

Originally Posted by Zachery

Your vBulletin database has thousands of tables? Did you mean thousands of rows.

I stand by what I said, if your db isn't doing alters quickly, something is wrong. Either bad MySQL performance, or bad hardware performance.

Neither Zachery, unless you want to explain your point to an expert in servers, i can pm you who he is if you like. We are on a new server with new hardware.

And i guess rows of tables ? - I am not expert with servers that is why we have a server admin. The changes had to run and be applied to each member we have on our forum, so think about altering fields/rows or whatever you call it for 1.5+ million member and see how fast you can complete this task and without getting your tables locked.

[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.

[katie hunter]

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.

It was more than 6 hours and you wouldn't be able to do anything other than wait for the task to completely finish. Have you tried DB's plugin, any of them on big sites? try it and see! you must have thousands of members. The table will lock to process each batch of changes and you will wait that much, even on a powerful dedicated server with 12 cores and 3.5 ghz speed and using SSD drives

[Zachery]

I wouldn't recommend their addons to my clients if they weren't worth their weight in gold.

The DBTech team, and in general the company, is committed to the quality of their software. They willing to listen, and open to ideas and suggestions.

At least, in my experiences, with my clients.

[final kaoss]

Kat if you haven't already, try asking George here. 949 pages and counting over there. Also, it might be a good idea to hook your tech guy up the results given to you and ask what his opinion on it is so he can implement or improve upon it.