Project

General

Profile

GX-Bug #67345

Deleting products takes a long time if there are many entries in the product_properties_index has 300.000 and more

Added by Marvin Muxfeld 9 months ago. Updated 9 months ago.

Status:
Erledigt
Priority:
Hoch
Assigned To:
Core-Entwickler
Category:
Adminbereich
Target version:
% Done:

0%

Estimated time:
Steps to reproduce:
Betroffene Versionen:
4.0.2.0, 4.1.2.0
Release Notes Langtext:

Das Löschen von Artikeln wurde verbessert, wenn man sehr viele Eigenschaftkombinationen hat

Story points-Velocity based estimate-

Description

Löschen von Artikeln dauert sehr lange wenn an viele Einträge im product_properties_index hat 300.000 und mehr

Das Problem hier ist, dass nach dem Löschen des Artikels oder der gewählten Artikel einmal komplett der gesamte Cache erneuert wird.
So auch der Categories Index und der Properties-Index. Das deuert bei 300.000 Kombinationen ca. 2. Minuten auf einem Strato Server.

Lösung:

Man löscht nur die Einträge aus dem Cache die auch die gelöschten Artikeln betreffen.


Deleting products takes a long time if there are many entries in the product_properties_index has 300.000 and more

The problem here is that after deleting the article or the selected products, the entire cache is completely renewed once.
This also applies to the Categories Index and the Properties Index. This means with 300.000 combinations about 2. minutes on a Strato server.

Solution:

You only delete those entries from the cache that also affect the deleted products.


Related issues

Copied from GX-Entwicklung - GX-Bug #67222: Deleting products takes a long time if there are many entries in the product_properties_index has 300.000 and moreErledigt

Actions

History

#1

Updated by Marvin Muxfeld 9 months ago

  • Copied from GX-Bug #67222: Deleting products takes a long time if there are many entries in the product_properties_index has 300.000 and more added
#2

Updated by Marvin Muxfeld 9 months ago

  • Status changed from In Bearbeitung to Testing
  • Assigned To changed from Marvin Muxfeld to Core-Entwickler
#3

Updated by Marvin Muxfeld 9 months ago

  • Assigned To changed from Core-Entwickler to Marvin Muxfeld
#4

Updated by Marvin Muxfeld 9 months ago

  • Status changed from Testing to Erledigt
  • Assigned To changed from Marvin Muxfeld to Core-Entwickler
#5

Updated by Marvin Muxfeld 9 months ago

  • Tags deleted (stable)

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 5 MB)