Thread: Forum Display Enhancements - vB Enterprise Translator
View Single Post
  #386  
Old 08-26-2009, 02:17 PM
Joppe111's Avatar
Joppe111 Joppe111 is offline
 
Join Date: Nov 2007
Location: Stockholm
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.

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.

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

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.

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.

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???
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01651 seconds
  • Memory Usage 1,767KB
  • 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
  • (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