vb.org Archive - Miscellaneous Hacks - vB Global Translator - Multiply your indexed pages & put search traffic on autopilot

Page 59 of 70

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Miscellaneous Hacks - vB Global Translator - Multiply your indexed pages & put search traffic on autopilot (https://vborg.vbsupport.ru/showthread.php?t=217329)

basilrath

08-03-2009 11:27 AM

Are we saying the mod is not workable in any shape or form?

cyc	08-03-2009 12:04 PM

Quote:

Originally Posted by basilrath (Post 1860657)

Are we saying the mod is not workable in any shape or form?

Nope, some guy with a tiny little forum posts vague replies. Which frankly, are no help to anyone. If I had a 3,000 post forum that suffered "massive problems" after installing this mod, I to would be extremely angry at my host or server administator. His attitude is perfectlly understandable ;)

If your website has appeal to people who's primary language isn't English, I reckon you'd be mad not to give it a go. Most of the people how have posted in this thread seem to be happy to share information or help each other.

imported_silkroad

08-03-2009 12:08 PM

Quote:

Originally Posted by NLP-er (Post 1860651)

Still have no idea :) As I wrote sitemap is not generated by this mod, but by vbSEO Sitemap Generator, so question should be for their staff. I don't care enough to ask them ;)

Oh! You should care ;)

Here is the reason why:

Google Sitemap Update Frequency and Sitemap Stats

Proper site maps make a huge difference when indexing :D

NLP-er

08-03-2009 12:23 PM

Quote:

Originally Posted by wolfstream (Post 1860652)

Wow, you really are clueless, aren't you?
Debugging PROVES that this mod caused the slow queries.

Previous to your mod:
Forum has 1-5 queries constantly running through mysql. Yeah, that's all, just 1-5, and that's normal and natural

Your mod installed:
Within 24 hours of having your mod installed, that 1-5 queries ran up to 50+, ALL with excessive time .

AFTER your mod removed
Forum has 1-5 queries constantly running through mysql. Yeah, that's all, just 1-5, and that's normal and natural

Don't even start with me and "that which you do not know". I develop and debug php/sql software for a living, it's what I do. I know full well how to develop, test, and work with software. In this case, the cause of the slow queries is quite evident. Just because you don't want to admit your product has this problem doesn't mean it's not so.

This product has nothing but slow queries. 10s response times? Yeah right, try 10 minutes, IF you're lucky.

LOL :D You are funny guy :) Especially with this "Don't even start with me". You have very huuuuuuuuuuge ego.

I was never discuss number of queries with you :) Keep focused! Or you don't have to because you are debug php/sql software for a living :D

You still didn't tell do you even know what kind of queries are in this mod. Can you show me which query is such slow for you and what is the time of that query? Or just debugging php/sql software for a living you don't have to identify the problem? :D

Are you able to point at least 1 slow query o master of masters who debug php/sql for a living?

Thanks for laugh which you gave me :D :up:

NLP-er

08-03-2009 12:25 PM

Quote:

Originally Posted by imported_silkroad (Post 1860668)

Oh! You should care ;)

Here is the reason why:

Google Sitemap Update Frequency and Sitemap Stats

Proper site maps make a huge difference when indexing :D

Good point - thanks :up: :)

imported_silkroad

08-03-2009 12:46 PM

Quote:

Originally Posted by NLP-er (Post 1860677)

Good point - thanks :up: :)

Thanks. Yea, the problem is that there is no other way (that we know of) to inform GoogleBot of the update frequencies, it is really inefficient to have Google just crawling for the sake of it without any "brains", especially for large forums.

Here is my other suggestions / recommendation for the future:

Using mod_rewrite, rewrite /forum/....html?hl=foo to be either /forum/foo/...html or /forum/....-foo.html

Modify vBSEO sitemap to change the way they have suggested indexing the flags:

Do not sitemap index like this:

Code:

index.html

index.html?hl=ja

index.html?hl=foo

Index like this (keep original content in tact):

Code:

index.html

forum/thread1.html

forum/thread2.html

forum/thread-etc.html

and then do an entire language as a group:

Code:

index.html

forum/thread1-ja.html

forum/thread2-ja.html

forum/thread-etc-ja.html

Repeat.

The reason for this is that it is easier to manage the (long term) indexing process if the language links are all nice and neat in a few sequencial sitemap files v. interwoven around each link. (The "interwoven process" in a nightmare, quite frankly).

Sorry, but the solution offered by the vBSEO team, while better than nothing, is not very manageable for large boards if you care about the convergence of Googles index with your sitemap. (Everyone should care if they care about SEO).

We track this on a weekly basis and have currently have nearly 92% convergence. Google does not keep dumping and recrawling, etc. (as it currently happening with the translated links) because there is no update frequency associated with the hl=foo links :erm:

Cheers.

imported_silkroad

08-03-2009 12:56 PM

Quote:

Originally Posted by wolfstream (Post 1860652)

This product has nothing but slow queries. 10s response times? Yeah right, try 10 minutes, IF you're lucky.

Actually, that is not true. We run this mod on a large board and have benchmarked it.

Yes, it adds a lot of time (slow queries) when a page is first translated; but after it is translated (and snug-as-a-bug-in-a-rug in the dB), it adds less than 100ms to a showthread query.

Naturally, since it must go across the network to sing the Google translation API song, that query will be very slow.

It's OK to beat up on these guys, since the code is free and you don't seem to understand it yet. ;-) They are used to it, but don't expect flowery replies when you beat them up ;)

I think they have done an outstanding job, and have donated one, of perhaps many, donations to these unsung heros of increased web traffic :-) In addition, I nominated this the "MOTM"! It is an amazing mod, and hopefully, will get better over time, if folks don't beat up the coders and chase them away!

cyc	08-03-2009 08:12 PM

Quote:

Originally Posted by imported_silkroad (Post 1860690)

That is also our experience with it :)

NLP-er

08-03-2009 08:52 PM

Quote:

Originally Posted by imported_silkroad (Post 1860690)

Yes, it adds a lot of time (slow queries) when a page is first translated; but after it is translated (and snug-as-a-bug-in-a-rug in the dB), it adds less than 100ms to a showthread query.

Naturally, since it must go across the network to sing the Google translation API song, that query will be very slow.

As I understood wolfstream, he was talking about DB SQL queries.

As you just wrote when page is first time translated long translation time is caused by http queries (requests) to Google for translation, not by SQL queries to DB (which are instant) :)

We are not able to make Google faster ;)

NLP-er

08-03-2009 08:52 PM

Also - thanks again for donation ;) :up:

All times are GMT. The time now is 01:57 PM.

Page 59 of 70

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02243 seconds Memory Usage 1,757KB 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 (3)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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
Messages: