Closed Bug 153540 Opened 22 years ago Closed 22 years ago

products/components tables don't have indexes

Categories

(Bugzilla :: Bugzilla-General, defect, P2)

Product:
Bugzilla
Component:
Bugzilla-General
Version:
2.17
Platform:
x86
Linux
Type:
defect

Tracking

()

Status:
RESOLVED FIXED
Milestone:
Bugzilla 2.18

People

(Reporter: bbaetz, Assigned: bbaetz)

References

Details

(Keywords: perf, Whiteboard: [schema])

Anyone know why neither products, components or versions tables have indexes? products should be: 'unique(product)' components should be: 'unique(value, program)' versions should be: 'unique(program, value)' with the appropriate checksetup changes to check for duplicates first. editproducts + friends already do this, though, so there shouldn't be any such duplicates. This should probably be done before bug 43600, to make the conversion code for that be simpler.
-> me. This probably isn't a major perf issue, since the tables are small, and only infrequently scanned. Bug 43600 makes it more of one, though, since name->id mappings will be done reasonably often.
Assignee: justdave → bbaetz
Blocks: 43600
Keywords: perf
Priority: -- → P2
Whiteboard: [schema]
Target Milestone: --- → Bugzilla 2.18
Blocks: 153445
This can't block 43600, since it's fixed. Gerv
No longer blocks: 43600
Well,this is basically fixed (by 43600) Versions aren't, but they're going to eventually become custom fields anyway.
Status: NEW → RESOLVED
Closed: 22 years ago
Resolution: --- → FIXED
Summary: products/components/versions tables don't have indexes → products/components tables don't have indexes
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.