Apache Allura™ / Tickets / #4265 slow mongo queries NEEDS ENSURE INDEX

#4265 slow mongo queries NEEDS ENSURE INDEX

Milestone: v1.0.0

Status: closed

Owner: Cory Johns

Labels: performance (126) v2 (44) sf-2 (994)

Component: General

Reviewer: Dave Brondsema

Updated: 2015-08-20

Created: 2012-05-22

Creator: Dave Brondsema

Private: No

These are examples of frequent slow queries. They probably just need indexes added. Maybe some query/code changes too.

Tue May 22 14:15:22 [conn521668] query project-data.artifact_feed query: { $query: { project_id: ObjectId('4e264007b9363c5665000359'), app_config_id: ObjectId('4e264008b9363c5665000360') }, $orderby: { pubdate: -1 } } ntoreturn:10 nscanned:1242030 nreturned:1 reslen:666 5234ms
Tue May 22 01:02:58 [conn513383] query pyforge.fs query: { $query: { category: "icon", project_id: ObjectId('4f7dae721be1ce3cb50009de') } } nscanned:39209 nreturned:1 reslen:167 1993ms
Tue May 22 00:23:21 [conn515210] query project-data.ticket query: { import_id: "tracker/447449/3510504" } ntoreturn:1 nscanned:2071437 reslen:20 1055ms

Discussion

Dave Brondsema - 2012-06-01

size: --> 2
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dave Brondsema - 2012-06-07

labels: performance --> performance, v2
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Cory Johns - 2012-06-08

status: open --> in-progress

assigned_to: Cory Johns
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Cory Johns - 2012-06-08

summary: slow mongo queries --> slow mongo queries NEEDS ENSURE INDEX

status: in-progress --> code-review

qa: Tim Van Steenburgh
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Cory Johns - 2012-06-08

allura: cj/4265

qa: Tim Van Steenburgh --> Ｄａｖｅ Brondsema
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dave Brondsema - 2012-06-08

status: code-review --> closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Apache Allura™

Forge software for hosting software projects

Milestone

Searches

Help

#4265 slow mongo queries NEEDS ENSURE INDEX

Discussion