On Thu, 12 Nov 2009 16:34:15 +0530 Sayamindu Dasgupta <[email protected]> wrote:
> Hi all, > First of all, a hearty congratulations to all those working behind the > scenes for Pootle 1.3 - the new version is awesome !! > > I have been trying to test migrate the Sugarlabs/OLPC instance of > Pootle to 1.3 (from 1.2), (we have around 11 projects and 1342 users) > and here are my preliminary notes: > > 1. For using MySQL, character_set_server = utf8 needs to be set in > my.cnf (somewhere inside /etc, depending on your distro) unfortunately Django does not guarantee the correct table encoding, best we can do now is document how to configure mysql to always use utf8 or if not possible how to create the database using utf8 encoding. > > 2. Long names cause problems while importing the old user data. Julen > points out that it is documented in > http://bugs.locamotion.org/show_bug.cgi?id=1225 I suggest that in case > a name is found to be > 30 chars, we try to split it up (using space > as delimiter) and choose the first item in the resulting list. If the > first item itself is > 30 chars, we trim off the excess chars. this is again a django limitation, we neither like the first name, last name split which doesn't apply to many cultures (including mine) nor the extremely low char limit. the work around u describe might be our best option at the moment. > 3. Somehow project metadata (description and names) are not imported. > I'll try to figure out what is going on I thought that was fixed. > 5. The index page takes a long time to load. I get messages in the > background like: hey where is point number 4? :-) first visit to front page is going to be slow yes because the stats for for all the languages and projects needs to be copied from statsdb and cached in the django cache, however subsequent visits should be fast. these stats will need to be recalculated from time to time though, to avoid experiencing slowdowns it is best to use memcached as the cache backend, this will ensure the stats live in cache longer. > Note that I am running Pootle via manage.py runserver, and I have done > refresh_stats. using apache with mod_wsgi will also boost performance. if you use a recent checkout from svn you'll notice on visiting the admin page a list of warnings/suggestions for improving performance. cheers, Alaa ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Translate-pootle mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/translate-pootle
