openerp-india team mailing list archive

["Yannick Vaucher @ Camptocamp" <1055561@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Hello,

I think there is an issue in the process of translation generation.
Lastly, I faced a case in which launching a translation process took ages.

Finally, I figured out that the main time spent was on the orm function
exists.

The following query was taking around 4 minutes:

SELECT id FROM account_analytic_analysis_summary_user WHERE id IN
(366694);

In fact this table contains more than 750k of rows. Maybe my local
postgres could be a bit optimized...

However, I was wandering why it had to be checked if it exists for
translations as the model itself contains only numeric fields so there
are no translation for a specific record.

What I found in table ir_mode_data was ~115 rows from module __export__
on the model account_analytic_analysis_summary_user. For each of those
rows the check is called...

So could you add a check before the exists either on the module, or on the model in trans_generate ?
I attach a very simple patch that resolved my issue.

Best regards,
Yannick

** Affects: openobject-server
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Server.
https://bugs.launchpad.net/bugs/1055561

Title:
  [6.0] Synchronize Translation check if exported ressources exist

Status in OpenERP Server:
  New

Bug description:
  Hello,

  I think there is an issue in the process of translation generation.
  Lastly, I faced a case in which launching a translation process took ages.

  Finally, I figured out that the main time spent was on the orm
  function exists.

  The following query was taking around 4 minutes:

  SELECT id FROM account_analytic_analysis_summary_user WHERE id IN
  (366694);

  In fact this table contains more than 750k of rows. Maybe my local
  postgres could be a bit optimized...

  However, I was wandering why it had to be checked if it exists for
  translations as the model itself contains only numeric fields so there
  are no translation for a specific record.

  What I found in table ir_mode_data was ~115 rows from module
  __export__ on the model account_analytic_analysis_summary_user. For
  each of those rows the check is called...

  So could you add a check before the exists either on the module, or on the model in trans_generate ?
  I attach a very simple patch that resolved my issue.

  Best regards,
  Yannick

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/1055561/+subscriptions