Slow queries when finding the revisions of a single entity. about auditor

[DamienHarper]

@SanderVerkuil #44 is fixed on master branch.
May you retry to set a composite unique index on id and object_id columns?

Nevertheless, it's quite hard to give hints on how to increase performance regarding queries without a better understanding of what queries you'd like to run and more precisely what where clauses you'd like to use. You can get very good results by using composite indices spanning on columns used in your where clauses.

[SanderVerkuil]

Ah allright, prior to that I might have to either truncate all the current tables that exist, or at the very least remove all the duplicated ID's, which might take a while.

But it might very well be the case that MySQL didn't like the fact that there were quite some duplicate ID's present, and that it would just perform a full table scan then.

And indeed, when I'm running the query as called in the bundle itself:

SELECT *
FROM audit_Entity
WHERE object_id = 865581
ORDER BY created_at DESC, id DESC
LIMIT 50

It isn't really fast, but it isn't slow either (not waiting 5 minutes for the results, but rather 45 seconds to fetch 8 results). I'll get back to you at a later time.

[DamienHarper]

@SanderVerkuil Ok, keep me updated of your findings once the tables are cleaned or truncated.

[DamienHarper]

@SanderVerkuil Any news on this?

[DamienHarper]

@SanderVerkuil I close this issue for now, feel free to reopen if needed.