vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Community Lounge (https://vborg.vbsupport.ru/forumdisplay.php?f=13)
-   -   I will be Back - Vbseo (https://vborg.vbsupport.ru/showthread.php?t=311520)

katie hunter 05-20-2014 11:32 AM

I will be Back - Vbseo
 
Well, this is a good news :d http://youtu.be/-YEG9DgRHhA

https://vborg.vbsupport.ru/external/2014/05/16.png

http://i.imgur.com/FuraO9j.png

http://www.vbseo.com/

Paul M 05-20-2014 12:01 PM

In my experience, vbseo are now hated as much as IB, I dont think many will be celebrating.

BirdOPrey5 05-20-2014 12:21 PM

I wouldn't believe anything put out by VBSEO unless you know exactly who is saying it and they have the means to make it true. You can't be sure who is speaking on behalf of the company- who has control of the domain, or anything.

katie hunter 05-20-2014 12:21 PM

Quote:

Originally Posted by Paul M (Post 2498585)
In my experience, vbseo are now hated as much as IB, I dont think many will be celebrating.

Well, i am still using vbseo and I can't find a better seo solution for VB other than Vbseo, so for me it is a good news.

I know several others who want to see it back and honestly i knew it will be back because my license key in the admin cp is always active and connected to vbseo domain and server, when the server goes down, the key verification use to show some type of an error, so i knew they were working on something but i never know what would it be.

I know VB 5.x has some seo features but they don't have expert seo developer. There are many Google guidelines and tips, and algorithmic changes that always come up with Google and VB 5.x isn't up to date with it. Content + optimized seo makes a site popular.

Quote:

Originally Posted by BirdOPrey5 (Post 2498589)
I wouldn't believe anything put out by VBSEO unless you know exactly who is saying it and they have the means to make it true. You can't be sure who is speaking on behalf of the company- who has control of the domain, or anything.

It is just news for now, so will find out later i guess.

I think IB/VB should be happy with these news but it appears you're not having too much faith in it ? I mean getting an SEO assistance for your product isn't going to affect VB license sales, i think it will help it because new customers are always looking for great forum software + great seo tools.

BirdOPrey5 05-20-2014 12:48 PM

I never recommend VBSEO and don't miss it. I don't think it is nearly as useful as many users think it is.

katie hunter 05-20-2014 01:05 PM

Quote:

Originally Posted by BirdOPrey5 (Post 2498595)
I never recommend VBSEO and don't miss it. I don't think it is nearly as useful as many users think it is.

It helped my site and I recommended it to others - I know that is a fact. But now days Google is changing a lot, VBseo would need to work harder than before but that doesn't mean it didn't fix many seo issues within VB 4.x. The amount of SEO settings Vbseo has, VB 4.x doesn't have.

Vb 4.x doesn't have all these settings and features which Vbseo has and VB 5.x are trying to learn many of Vbseo features still.

http://i.imgur.com/XFM0w6N.png

https://vborg.vbsupport.ru/external/2014/05/21.png

Here is a Jira that VB 5.x would still yet to implement like Vbseo and add more onto it

https://vborg.vbsupport.ru/external/2014/05/1.gif Sitemap Settings

http://tracker.vbulletin.com/browse/VBV-12446

Status: BRB Future Release

final kaoss 05-20-2014 01:37 PM

Quote:

Originally Posted by katie hunter (Post 2498590)
Well, i am still using vbseo and I can't find a better seo solution for VB other than Vbseo, so for me it is a good news.

Say hello to Dragonbyte Seo, it's free to use and it's feature packed. I would list all of the features here but there would be a huge wall of text if I did. :D


Quote:

Originally Posted by bzcomputers (Post 2497195)
There are no guarantees, but there is hardly any comparison between what was vbSEO and what is DragonByte Tech the makers of DBSEO.

vbSEO
A) 1 mod (2 if you count there vbSEO Sitemap mod which was an add-on)
B) Continually questionable support. They had'nt supported their product(s) on here or in their own forums for nearly 2 1/2 years (and unfortunately people were still buying the product). In the nine years they were members here they only made about 60 posts.

DragonByte Tech
A) Over 80 supported mods for vBulletin which includes mods for vB3, vB4, and vb5. They are very familiar with the code and are continually putting out updates to products weekly.
B) They have their own active support forum which the respond to questions/requests to daily. They are also active here on vbulletin.org nearly daily.
C) They've produced numerous Mods of the Month and are still continually producing new products to support all versions of vBulletin.
D) Are considered by many on here to have exceptional support for their products.

Quote:

Originally Posted by DragonByte Tech (Post 2497309)
You can read this manual entry for the explanation of that error: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

This mod has received 15 updates since it was flagged stable :)

It shouldn't, though we haven't explicitly tested this mod on Litespeed.

It's impossible for us to make any form of guarantees regarding the lifetime of the modification, unfortunately. To take it straight to 11; I could get killed in any manner of horrible ways tomorrow, leaving the rest of the team scrambling to support it :p

On a more serious note: We have no plans of discontinuing support for DBSEO. It's our top priority, and due to the nature of the mod it will remain our top priority for the foreseeable future.

I don't think you should consider the money you spent on vBSEO a waste. You got the functionality you paid for, and the security vulnerabilities vBSEO currently suffers from was not something yourself nor the vBSEO team could have foreseen.

If DragonByte Tech ever closes its doors, or anything happens that would even remotely affect our ability to do business (extended holidays, injuries/illnesses/deaths rendering one of our team members incapable of working for extended periods of time), we would send out a newsletter from our site informing our customers of this.

We would never simply disappear without a word, leaving our customers high and dry. You would always be informed to the best of our abilities, leaving you time to seek alternative solutions if you feel that this is the best course of action for your site.


Fillip


katie hunter 05-20-2014 01:45 PM

Quote:

Originally Posted by final kaoss (Post 2498604)
Say hello to Dragonbyte Seo, it's free to use and it's feature packed. I would list all of the features here but there would be a huge wall of text if I did. :D

I really stay away from all of Dragonbyte plugins, he creates his plugins in a way that heavily alters VB tables. Something I also don't like very much with any plugin that is coded that way. It locks my database, every time i try to export or import his product xml plugin, it would take 6+ hours for me and the site would be down. Why ? because it applies changes to all my tables and when you have a site with 1.5 million registered member, all these tables needs to be altered. It was a nightmare for me trying to uninstall few of dragonbyte plugins. And you can't interfere when the tables gets locked many times, I would just leave the site and come back later and see if the task is done or not.

I am aware of his SEO plugin but i wouldn't install it for that fact mentioned above + I personally don't think it surpasses Vbseo. I mean Fillip isn't an SEO expert, he creates plugins but that doesn't mean he knows how SEO works.

Edit: May be i will look at Fillip's plugin for my new site, at least it won't have all these tables to alter. I see Fillip did few new updates that are SEO good like microdata. I will test it later for my new launched project and see how it will work. In the mean time will see what Vbseo will be up to.

Zachery 05-20-2014 06:23 PM

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

DragonByte Tech 05-20-2014 06:40 PM

Quote:

Originally Posted by katie hunter (Post 2498609)
I really stay away from all of Dragonbyte plugins, he creates his plugins in a way that heavily alters VB tables. Something I also don't like very much with any plugin that is coded that way. It locks my database, every time i try to export or import his product xml plugin, it would take 6+ hours for me and the site would be down. Why ? because it applies changes to all my tables and when you have a site with 1.5 million registered member, all these tables needs to be altered. It was a nightmare for me trying to uninstall few of dragonbyte plugins. And you can't interfere when the tables gets locked many times, I would just leave the site and come back later and see if the task is done or not.

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.

Quote:

Originally Posted by katie hunter (Post 2498609)
I am aware of his SEO plugin but i wouldn't install it for that fact mentioned above + I personally don't think it surpasses Vbseo. I mean Fillip isn't an SEO expert, he creates plugins but that doesn't mean he knows how SEO works.

I know enough to know that there are multiple features in vBSEO that are either irrelevant in today's SEO market (whitespace stripping, pingback/linkback) or directly harmful and will get your site penalised (archive links in footer).

DragonByte SEO was designed in cooperation with www.SEOvB.com and we will continue to work with them in the future on implementing new, modern SEO practices in future versions. We are currently working to improve the stability of the existing feature set to make sure it works on as many configurations as possible.

I also know that it's bad customer relation to leave multiple exploits unpatched. DBTech itself nearly got exploited because I had forgotten to remove the root vbseo.php file from our server, from back when we ran vBSEO.
Without giving away too many details in the interest of protecting forums still running vBSEO, our error logs showed that malicious users were able to bypass any and all protection running on our AdminCP directory (permissions & .htaccess) and attempted to run code in an admin environment. They were only stopped by the fact that critical files in the /vbseo/ directory had been deleted.

Lastly, I also know that DragonByte SEO does not feature any of the licence checking mechanisms found in vBSEO. This means that even if our servers go down, or we close our doors for whatever reason, any and all copies of DragonByte SEO will continue to work until the end of time.
I honestly don't know the extent of the vBSEO DRM, but I do know that we do not use any form of DRM at all, meaning the stability and continued operation of our service is not a requirement for our products to function.

I sincerely hope your site manages to stay off the radar of the malicious individuals that know how to exploit these bugs in vBSEO, and that should vBSEO come back into operation, they will honour existing licence agreements to fix the existing bugs.


Fillip

ForceHSS 05-20-2014 07:04 PM

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 05-20-2014 07:22 PM

Quote:

Originally Posted by Zachery (Post 2498664)
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.

Quote:

Originally Posted by ForceHSS (Post 2498673)
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 05-20-2014 07:34 PM

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

katie hunter 05-20-2014 07:54 PM

Quote:

Originally Posted by Zachery (Post 2498686)
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 05-20-2014 08:35 PM

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 05-20-2014 08:45 PM

Quote:

Originally Posted by Zachery (Post 2498691)
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 05-20-2014 09:00 PM

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 05-20-2014 09:03 PM

Quote:

Originally Posted by Zachery (Post 2498694)
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 05-20-2014 09:48 PM

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 05-20-2014 09:49 PM

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.

tpearl5 05-21-2014 01:11 AM

Quote:

Originally Posted by katie hunter (Post 2498695)
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

Right, and any modification that adds columns to a table is going to lock the table while those columns are added. As others have stated it shouldn't take that long even with that many users, especially with that much hardware. Something with your mysql configuration isn't optimal or needs to be adjusted.

Also, do you mean 2.5mhz? Intel E5 processors? Not that it matters, that's still a lot of processing power.

Anyway, I have a feeling this new vbSEO management has something to do Juan's sister: http://admin-talk.com/threads/dear-v...rations.43684/

--------------- Added [DATE]1400638628[/DATE] at [TIME]1400638628[/TIME] ---------------

Quote:

Originally Posted by katie hunter (Post 2498683)
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.

Umm.. how is what happened not treating their members badly? The family dispute had nothing to do with the product continuing to be sold with no support, and then the site just closing without notice. People were being strung along for an update for months. Sales were in decline, Juan jumped ship with customers still on board.

katie hunter 05-21-2014 04:50 AM

Quote:

Originally Posted by tpearl5 (Post 2498732)
Right, and any modification that adds columns to a table is going to lock the table while those columns are added. As others have stated it shouldn't take that long even with that many users, especially with that much hardware. Something with your mysql configuration isn't optimal or needs to be adjusted.

Also, do you mean 2.5mhz? Intel E5 processors? Not that it matters, that's still a lot of processing power.

Anyway, I have a feeling this new vbSEO management has something to do Juan's sister: http://admin-talk.com/threads/dear-v...rations.43684/

--------------- Added [DATE]1400638628[/DATE] at [TIME]1400638628[/TIME] ---------------



Umm.. how is what happened not treating their members badly? The family dispute had nothing to do with the product continuing to be sold with no support, and then the site just closing without notice. People were being strung along for an update for months. Sales were in decline, Juan jumped ship with customers still on board.

No, a 3.5 GHZ, we don't use a 2.5 GHZ.

It has nothing to do with mysql, I've said that before and i pmed Zachery who my server admin and his company is. He would know right away his reputation on WHT, so no dispute into that. You can't teach experts their job that they know inside and out.

I mean i can listen to an advise but i know what i was being told. Also DB's plugins are the only plugins that does this, i have many installed plugins and they get installed right away, why ? because they don't heavily alter many vb tables and that is a fact. If I had a small community, yes DB plugin will be installed right away.

As for Vbseo, Juan might have made mistakes but the blame comes from his sister as well and heavily but i don't want to even talk about this family dispute, the good news is that somehow things might turn out better for vbseo, will just have to see.

Zachery 05-21-2014 05:50 AM

I wouldn't trust vbseo with any site I ever ran, ever. I am personally tired of still cleaning up after their messes for the last few years.

Paul M 05-21-2014 03:58 PM

Quote:

Originally Posted by katie hunter (Post 2498692)
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.

Table alters have to lock the table, thats pretty obvious I would have thought.

If your mysql server is taking 6 hours to alter a 1.5 million records User table, then its badly broken.

katie hunter 05-21-2014 04:04 PM

Quote:

Originally Posted by Paul M (Post 2498806)
Table alters have to lock the table, thats pretty obvious I would have thought.

If your mysql server is taking 6 hours to alter a 1.5 million records User table, then its badly broken.

Paul, no. You can pm Zachery for my server admin company if you like and see his reputation on WHT, I don't think you will argue your point with an expert. Or may be the misunderstanding is coming from me? There was a lot of changes, tables gets locked to safely finish the changes and thousands of changes does take time. I've seen it in the logs.

People just keep saying stuff that they have no first hand knowledge of.

Like I said try any of DB's plugin on with big sites that have million of threads, posts, and registered members and see how fast your will finish important the xml. You can share the result later if you like.

tpearl5 05-21-2014 04:34 PM

Quote:

Originally Posted by katie hunter (Post 2498741)
No, a 3.5 GHZ, we don't use a 2.5 GHZ.

So I'm assuming you have a two processor machine with 6 cores each, right (you said 12 cores)? The fastest 6 core processor that Intel makes is the E7-8893 v2 at 3.4GHz - it's brand new, very expensive, and not a lot of hosts are using it if at all. Am I missing something? Regardless, it doesn't matter, but this is telling me that you don't know what you have.

Quote:

Originally Posted by katie hunter (Post 2498741)
It has nothing to do with mysql, I've said that before and i pmed Zachery who my server admin and his company is. He would know right away his reputation on WHT, so no dispute into that. You can't teach experts their job that they know inside and out.

I'm sorry, I'm not here to debate someone's credentials at all, but your issue absolutely is a mySQL issue. I'm not an expert by any means, but I know a mysql bottleneck when I see it. It's possible that your guy hasn't allocated any resources to actually adding data to tables.

Quote:

Originally Posted by katie hunter (Post 2498741)
I mean i can listen to an advise but i know what i was being told. Also DB's plugins are the only plugins that does this, i have many installed plugins and they get installed right away, why ? because they don't heavily alter many vb tables and that is a fact. If I had a small community, yes DB plugin will be installed right away.

DB Tech is definitely not the only one that modifies tables. The alternative modifying a table (if it needs to be done) is adding a new table, which is less efficient (and requires a lot more join queries, which are expensive), and will be slower. You're kind of saying that all plugins are created equal though and that's definitely not the case. Some do not need to store data (which will naturally install more quickly) while others do.

Quote:

Originally Posted by katie hunter (Post 2498741)
As for Vbseo, Juan might have made mistakes but the blame comes from his sister as well and heavily but i don't want to even talk about this family dispute, the good news is that somehow things might turn out better for vbseo, will just have to see.

Source? Hopefully that's the case, but I wouldn't count on it. Especially with DB tech providing a viable replacement.

katie hunter 05-21-2014 04:38 PM

Quote:

Originally Posted by tpearl5 (Post 2498815)
So I'm assuming you have a two processor machine with 6 cores each, right (you said 12 cores)? The fastest 6 core processor that Intel makes is the E7-8893 v2 at 3.4GHz - it's brand new, very expensive, and not a lot of hosts are using it if at all. Am I missing something? Regardless, it doesn't matter, but this is telling me that you don't know what you have.

I'm sorry, I'm not here to debate someone's credentials at all, but your issue absolutely is a mySQL issue. I'm not an expert by any means, but I know a mysql bottleneck when I see it. It's possible that your guy hasn't allocated any resources to actually adding data to tables.

DB Tech is definitely not the only one that modifies tables. The alternative modifying a table is adding a new table, which is less efficient (and requires a lot more join queries, which are expensive), and will be slower.

Source? Hopefully that's the case, but I wouldn't count on it. Especially with DB tech providing a viable replacement.

Intel e5 1650v2 (Six real / 12HT cores @ 3.5ghz)
32gb ram
128gb Samsung 840 Pro SSD
600gb 15k rpm sas hdd

I know what i bought.

The reason I never share my server admin company name in this thread because of all these wrong statement flying left and right and b/c the moment i do and see you guys still arguing, i am sure a lot of WHT vets and customers will come right in disputing these because we're talking about an expert server admin with extensive knowledge in the security and server field, especially linux and has a high reputation. WHT server companies like Softlayer, Webnx and so on comes to him for big issues.

tpearl5 05-21-2014 04:49 PM

Quote:

Originally Posted by katie hunter (Post 2498817)
Intel e5 1650v2 (Six real / 12HT cores @ 3.5ghz) x2
32gb ram
128gb Samsung 840 Pro SSD
600gb 15k rpm sas hdd

I know what i bought.

Ah I forgot about that one. I stand corrected.

Zachery 05-21-2014 05:49 PM

That's great for him, but that doesn't mean squat when we see alter queries taking 1+ hours on fairly small tables.

I've done alters on the vBulletin (5) node table on my TINY dual core atom with 3+ million node tables in under an hour. Same goes for post/thread/users.


I pestered digitalpoint on twitter, his user table alters are mostly "quick", and he has about half as many tables as you do.

Further, being on an SSD, if the DB is actually being hosted on the SSD, 6+ hours for a million rows is just batshit insane. SOMETHING is wrong with your configuration.

Paul M 05-21-2014 07:18 PM

Quote:

Originally Posted by katie hunter (Post 2498809)
Paul, no. You can pm Zachery for my server admin company if you like and see his reputation on WHT, I don't think you will argue your point with an expert.

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

Quote:

Originally Posted by katie hunter (Post 2498809)
Like I said try any of DB's plugin on with big sites that have million of threads, posts, and registered members and see how fast your will finish important the xml. You can share the result later if you like.

I have no intention of ever installing dbtech plugins on any site, for totally unrelated reasons.

katie hunter 05-21-2014 07:47 PM

Quote:

Originally Posted by Paul M (Post 2498842)
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 (Post 2498668)
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 05-21-2014 09:02 PM

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

DragonByte Tech 05-21-2014 09:56 PM

Quote:

Originally Posted by katie hunter (Post 2498845)
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 05-21-2014 10:22 PM

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

final kaoss 05-21-2014 10:41 PM

1 Attachment(s)
Quote:

Originally Posted by wjkingsnorth (Post 2498877)
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 05-22-2014 04:24 AM

Quote:

Originally Posted by DragonByte Tech (Post 2498868)
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

Quote:

Originally Posted by DragonByte Tech (Post 2498668)
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
Quote:

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 05-22-2014 01:00 PM

Quote:

Originally Posted by katie hunter (Post 2498845)
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. :cool:

katie hunter 05-22-2014 03:31 PM

Quote:

Originally Posted by Paul M (Post 2498936)
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. :cool:

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.

Quote:

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 05-22-2014 03:41 PM

Quote:

Originally Posted by Zachery (Post 2498694)
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 05-22-2014 03:48 PM

Quote:

Originally Posted by final kaoss (Post 2498955)
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.

Quote:

Originally Posted by final kaoss (Post 2498955)
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.


All times are GMT. The time now is 03:28 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01542 seconds
  • Memory Usage 1,959KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (40)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete