Thread: Forum Display Enhancements - vB Enterprise Translator
View Single Post
  #394  
Old 08-26-2009, 05:12 PM
NLP-er's Avatar
NLP-er NLP-er is offline
 
Join Date: Aug 2008
Location: Wrocław
Posts: 1,353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Joppe111 View Post
Hi NLP-er!

We have installed this mod and I am really excited about it as I belive it can increase traffic quit a lot! But - there are some problems....

As far as I can see, the translations are NOT cached - or more possibly - it ignores to fetch the cached translation and always makes a query to Google. It simply isn't any difference in time when opening a page that has been opened previously compared to the first time.
What was your way of mesurment? How are you sure that page wasn't translated before? Dissable cache - make several tests. Enable cache - make several tests. Take average time for booth and let me know about your results

Quote:
Originally Posted by Joppe111 View Post
If I enable more than one language the mod causes MySQL to be overloaded. The site has quit a lot of traffic but I suspect that the main problem is when search engine bots are opening many pages to be translated. If all languages are enabled it can take more than a minute to get the page translated and fully rendered. It will also cause tons of MySQL errors and the whole forum becomes unresponsive.
You can choose which languages you want to have cached or dissable cache at all. It is fully configurable.
"can take" - does it means that you checked it or you are worried? If you checked it - configure your cache appropriatelly to your needs. If you are worried - make stress test and check it.
"It will cause" - you expect this or you had this? What errors you are writing about - give me error log. I cannot help with your actual description.

Quote:
Originally Posted by Joppe111 View Post
When testing with just one language, it still takes approx the double time for a previously translated page to be fully loaded compared to a "original page". Example: http://www.experiencefestival.com/fo...gust-15-a.html
It is not a problem. Try to find faster translation mod Translation takes time. Even from cache. And alvays will take longer that oryginal page, because oryginal page is generated first and then translated. Mod will not translate something which wasn't generated first.

Quote:
Originally Posted by Joppe111 View Post
To open and load the "original page", i.e. the original English page, takes about 4-5 seconds. To open the Swedish translation, when only having one language enabled, will take double the time, 9-10 seconds, regardless if it has been opened before. When having 5-6 languages enabled it will take 20-30 seconds. When having all languages enabled the whole site gets unstable.
There is no any connection between mod speed and number of enabled translations. Mod works same way no mather how many translations you have on. It is your server load. If you cannot stand your traffic I cannot help in that.
I really don't know what are you expecting from me at this point. Please describe me what are your suggestions

Quote:
Originally Posted by Joppe111 View Post
From what I can understand the mod is actually writing to MySQL, but, it looks like it fails to see that a page is cached and will always make a query to Google. I guess that the reason for MySQL-errors is that to many requests for writing to MySQL is made when all or several languages are enabled, and I guess that the reason for the long wait for the translated page is because many languages enabled means a lot of queries to Google., ie it becomes a long queue to Google.
Once again - what errors?

About cache - go to file vbenterprisetrnslator_functions.php, find function vbet_getFromCache and change every line in this function with return (but not return null) to return 'FROM CACHE';. Upload and you will see which parts are taken from cache (if any). After that undo changes and upload oryginal file.

Enabled language doesn't mean any query to Google. Translation of page - does.

Quote:
Originally Posted by Joppe111 View Post
From what I can see all settings in AdminCP is as they should:

”Use cache” is set to yes
”Cache Time To Live” is set to 90 days
”Select grouped translations” is now Yes, have tested with No but it doesn’t make any difference
“Cache details” is set to all languages

I have now only Swedish and German enabled but it takes forever to open an already translated page... What is wrong???
Cannot tell without possiblity to check it.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01268 seconds
  • Memory Usage 1,793KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete