history grow too fast when using projeqtor with daily(or more) cron import
We are importing a lot of datas 3 times per days ( bill / customer / supplier / expense / order... ) but our systeme is not able to send only modifications so we import in mass and projeqtor cron is makihng update or not ...
Since several days, we see that projeqtor is really slow when we put project details on screen, first all all we were thinking of calculation for invoice / order / expense ... but yesterday it was so ugly that we try to find the trouble ....
History table was more than 600 000 lines and 400mo .... !!!
We discover that for each line of import even when existing, projeqtor write in history for calculation update / margin update ... cost !!!!!!!
With 3 batchs imports per days ( around 20.000 lines of order / invoice / ... ) for updating from CEGID ... situation is not realistic
Could it be possible to desactivate history for importation, with an option for exemple or with other solution ?
Now we create a script specific to erase datas history from import ... but it is really complex and other who want to synchronise will have the same trouble...
History from datas imported several times a day is not pertinent for us
Do you have a solution to avoid below script ?
............................
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectExpense'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProviderOrder'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='Command'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProviderBill'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='Provider'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ImportLog'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='bill'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='Expense'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='billSum'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='plannedCost'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='realCost'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='expenseAssignedAmount'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='expenseLeftAmount'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='expensePlannedAmount'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='totalAssignedCost'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='totalLeftCost'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='totalPlannedCost'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='totalRealCost'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='expenseRealAmount'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='commandSum'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='marginCost'"
mysql --host=XXXXXXXXXXXXXXXXXXXXXX --binary-mode=1 --database=projeqtor -e "DELETE FROM history WHERE reftype='ProjectPlanningElement' and colName='marginCostPct'"
Thanks for your support.
LR