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

**Text Removed**

[basilrath]

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

[cyc]

Originally Posted by basilrath

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]

Originally Posted by NLP-er

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

[NLP-er]

Originally Posted by wolfstream

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

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?

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 :up:

[NLP-er]

Originally Posted by imported_silkroad

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

Good point - thanks :up:

[imported_silkroad]

Originally Posted by NLP-er

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:

index.html
index.html?hl=ja
index.html?hl=foo

Index like this (keep original content in tact):

index.html
forum/thread1.html
forum/thread2.html
forum/thread-etc.html

and then do an entire language as a group:

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]

Originally Posted by wolfstream

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]

Originally Posted by imported_silkroad

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.

That is also our experience with it

[NLP-er]

Also - thanks again for donation :up:

[NLP-er]

Originally Posted by imported_silkroad

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