Composite index on diffs table
Reported by Ben Hood | October 13th, 2011 @ 01:15 PM | in 0.9-series (closed)
The query
select max(reporteddi0_.seq_id) as col_0_0_ from diffs reporteddi0_ where reporteddi0_.domain=:1
is doing a full table scan (Cost 3027). There is an index on seq_id but because of the domain predicate it doesn’t help. What would probably help is a composite index on domain and seq_id.
Comments and changes to this ticket
-
Ben Hood October 13th, 2011 @ 01:45 PM
(from [b5ac45111454edd5d994ed2376f90227be149e99]) [#385] Add composite index on sequence id and domain for diffs table https://github.com/lshift/diffa/commit/b5ac45111454edd5d994ed2376f9...
-
Ben Hood October 13th, 2011 @ 02:01 PM
(from [0be5974bbf67bd271aca6d6607410a2cd1326832]) Merge pull request #90 from lshift/385
[#385] Add composite index on sequence id and domain for diffs table https://github.com/lshift/diffa/commit/0be5974bbf67bd271aca6d660741...
-
Ben Hood October 13th, 2011 @ 05:53 PM
- State changed from “open” to “resolved”
- Assigned user changed from “Ben Hood” to “Paul Jones”
This has been merged into master, but requires some post QA
-
Ben Hood November 14th, 2011 @ 05:35 PM
- Milestone set to “0.9-series”
- Milestone order changed from “129” to “0”
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
A Real Time Differencing Tool.
Ben Hood