DragonPrime - LoGD Resource Community
Welcome Guest
  • Good evening, Guest.
    Please log in, or register.
  • July 21, 2018, 12:46:29 AM
Home Forums News Downloads Login Register Advanced Search
* * *
DragonPrime Menu
Login
 
 
Resource Pages
Search

Pages: [1]   Go Down
  Print  
Author Topic: translation performance  (Read 3181 times)
0 Members and 1 Guest are viewing this topic.
KhanTervel
Guest
« on: February 20, 2005, 11:52:00 PM »

Hi again,

Sorry for bothering you again, but is there someone that's successfully running a tranlationtool-based lotgd?

I am doing performance tests at the moment and it seems that a couple of users are able to lock out the whole database for a relatively long time. I measured the queries to the db and even in non-fully translated page, scripts are issuing more than 200 queries to the database ( i guess if translation is finished and i am not collecting untranslated texts any more this number will lower to 100-150 queries which is again too much per user) !

What about doing some additional file-based translation scheme, e.g. when finished collecting and translating texts to the db we can generate module(namespace)-based language files with, for example,  some lang. assoc. arrays (or even constants). Then for each module (e.g. when hooking) needed lang files can be once included and the output functions can easily get the values straight from the hashes and modify them. I think this way the translation can be even simplified as some of the users may prefer editing language files and deal with the encoding of the files than run through the interface and deal with the encoding of the database.



Best Regards,

Logged
XChrisX
Global Moderator
Mod God
*****
Offline Offline

Posts: 4647

Be aware of the squirrel!


View Profile WWW
« Reply #1 on: February 21, 2005, 01:09:55 AM »

We are running are relatively large server with almost fully translated texts...

the collection of untranslated texts should *not* be used on a live-server because of the problems mentioned by you.

The only thing would be to lower disable perma-collection and set the tl_maxuser to 2 or 3 users.

Doing so, you won't collect so many texts, but the server will not be so highly burdened...

It's best, if you collect text's on your dev-server and then copy the contents of your translations table to your live server.

BTW: When the collection of texts is disabled the database translation (along with all other improvements) still works faster than the 0.97 structure!
Logged

Running for more than three years now:
KhanTervel
Guest
« Reply #2 on: February 21, 2005, 09:03:28 AM »

Can you share, of course if it's appropriate, some more information about server load - hardware, network and lotgd load. Thank you  Smiley !
Logged
XChrisX
Global Moderator
Mod God
*****
Offline Offline

Posts: 4647

Be aware of the squirrel!


View Profile WWW
« Reply #3 on: February 21, 2005, 09:53:50 AM »

I've already said somewhere something about 300GB per month...
Logged

Running for more than three years now:
Pages: [1]   Go Up
  Print  
 
Jump to:  


*
DragonPrime Notices
Please take the time to read the FAQ and browse the DragonPedia

Support Us
No funds raised yet this year
Your help is greatly appreciated!
Recent Topics
DragonPrime LoGD
Who's Online
45 Guests, 0 Users
Home Forums News Downloads Login Register Advanced Search