https://bugs.kde.org/show_bug.cgi?id=438253
Maik Qualmann <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REPORTED |CONFIRMED Ever confirmed|0 |1 --- Comment #2 from Maik Qualmann <[email protected]> --- The delete tags trigger is really extremely slow here with my test tags table with almost 40,000 entries. Even under MySQL Command I cannot delete 1000 tags, I canceled it. I can optimize the trigger, now deleting 10,000 tags takes about 20 minutes. Not really nice either, but at least a lot better. But you also have to consider that deleting such a large number of tags rarely or never occurs with users. Our old method of managing a TagsTree was also extremely slow, as the entire Tags Table columns "lft" and "rgt" always had to be recalculated. It's amazing to me that MySQL is so slow here. Maik -- You are receiving this mail because: You are watching all bug changes.
