Add/Update indexes for queries done by the API (tracking)
Open, MediumPublic
Actions

Assigned To

None

Authored By

	Reedy
	Mar 6 2010, 6:10 PM

Description

Per r63301#c6121

Listing under API, but UI probably needs updating too, and possibly even some schema changes? (if indexes missing etc)

Version: unspecified
Severity: normal

Status	Subtype	Assigned	Task
Open		None	T28394 Missing Indexes, Inefficient queries and alike (tracking)
Open		None	T24744 Add/Update indexes for queries done by the API (tracking)
Resolved		Catrope	T16712 API: logevents do not have a namespace filter
Open		None	T16711 Implement a namespace filter for the logging table
Declined		None	T29922 API: add minsize/maxsize param to list=filearchive
Resolved		Catrope	T26650 Fix API to work with categorylinks changes
Resolved		Reedy	T23346 Make deleted images searchable by hash (disabled in Miser Mode)
Resolved		Ciencia_Al_Poder	T28872 API: allow listing of files uploaded by user
Open	Feature	None	T29204 API: Add timestamp sort to list=filearchive
Open	Feature	None	T31139 API: allow listing of deleted files by user who deleted them
Open	Feature	None	T29609 API: add information about deletion to list=filearchive
Open	Feature	None	T54415 Allow mime search of api works in miser mode

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:00 PM

• bzimport set Reference to bz22744.

• bzimport added a subscriber: Unknown Object (MLST).

"Make sure all relevant indexes are used in ApiQueryLogEvents" for comment above

Generalising, per r66891#c7089 - "There is no index on (prefix, title, from), although IMO such an index makes a lot of sense and should be added"

(In reply to comment #1)

Generalising, per r66891#c7089 - "There is no index on (prefix, title, from),
although IMO such an index makes a lot of sense and should be added"

That was dealt with in r69721 by Roan

(In reply to comment #0)

Per r63301#c6121

Listing under API, but UI probably needs updating too, and possibly even some
schema changes? (if indexes missing etc)

r93211

Leaving open/repurposing as a tracking bug