Bug #4944

Clean DB when transfer have too heavy queries

Added by ddurieux over 6 years ago. Updated over 6 years ago.

Status:ClosedStart date:06/02/2014
Priority:NormalDue date:
Assignee:ddurieux% Done:

100%

Category:Inventory
Target version:0.84.6

Description

On peut déjà modifier le code des requetes pour optimiser (7 secondes -> 0.5 secondes).

Mais le code de clean ne devrait pas être dans le code du transfert, car exécuté à chaque transfert et ça coute cher en requetes sur la base de données.

Donc soit :

1/ On ajoute un script cli dans glpi/scripts qui permette de nettoyer la DB

2/ Ajouter une tache cron qui va nettoyer la DB


Related issues

Related to GLPI-PROJECT - Task #4959: Clean DB process used before transfer on cron job ? New 06/11/2014

Associated revisions

Revision 22990
Added by ddurieux over 6 years ago

Optimize queries for clean in transfer. references #4944

Revision 22991
Added by ddurieux over 6 years ago

Optimize queries for clean in transfer. references #4944

History

#1 Updated by moyo over 6 years ago

  • Category set to Inventory
  • Status changed from New to Resolved
  • Assignee set to ddurieux
  • % Done changed from 0 to 100

Premier partie OK. je créé une autre tâche liée.

#2 Updated by moyo over 6 years ago

  • Related to Task #4959: Clean DB process used before transfer on cron job ? added

#3 Updated by moyo over 6 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF