Hello, we use a Pootle-Server (2.0.0) to do translations for our software releases with xliff-files. The server runs with mod_wsgi on an apache-webserver. All optional modules are installed - the admin pages shows no missing dependencies. Only the use of MySQL is proposed. We have about 43,000 strings with about 137,000 words per language. They are split into many xliff-files with a size generally lower than 1MB. This files are not "small", but we have only about 15MBs overall per language used. This should be no problem I think.
We have a job, which synchronises the pootle-xliff-files with the source-files of our application. This task changes and (if needed) creates or deletes xliff-files. After this job finished I try to open the pootle-mainpage. This take a very long time (up to 7 minutes). I tried to call the refresh_stats-task before. This runs about 20 minutes, but it doesn't speed up the pootle-mainpage first call. The second and all further calls are handled immediately. I tried to figure out, what the server is doing. There is a single apache-process which was running. There were no further log-outputs which may give a hint. Now the questions: 1. How can I speed up the first call of pootle-mainpage? 2. Why does the refresh_stats-task have no effect on this? 3. How can I obtain more log-output. We run pootle 1.2 in an installed version without apache before and there many more log-entries were created. 4. May changing from SQLite to MySQL bring more performance. When I tried this some time ago only the pootle.db was migrated to MySQL. The stats.db was left on SQLite. The last one seems to cause the problem. Thanks for your help. Greetings Johannes Ahlers ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Translate-pootle mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/translate-pootle
