search

LMFDB / lmfdb-inventory

inventory of the lmfdb database
3 stars 14 forks source link

artin.representations missing index on BadPrimes #64

Closed edgarcosta closed 6 years ago

edgarcosta commented 7 years ago

I'm not sure adding the index will help very much.

But here are some slow queries:

artin.representations command: count { count: "representations", query: { BadPrimes: { $all: [ "43" ] }, GaloisConjugates.Sign: 1, Hide: 0, Indicator: 1, Galois_nt: [ 11, 5 ] } } planSummary: IXSCAN { Hide: 1, Galois_nt: 1 } keyUpdates:0 writeConflicts:0 numYields:73 reslen:62 locks:{ Global: { acquireCount: { r: 148 } }, Database: { acquireCount: { r: 74 } }, Collection: { acquireCount: { r: 74 } } } protocol:op_query 104ms
artin.representations command: count { count: "representations", query: { BadPrimes: { $all: [ "43" ] }, GaloisConjugates.Sign: 1, Hide: 0, Indicator: 1, Galois_nt: [ 11, 5 ] } } planSummary: IXSCAN { Hide: 1, Galois_nt: 1 } keyUpdates:0 writeConflicts:0 numYields:73 reslen:62 locks:{ Global: { acquireCount: { r: 148 } }, Database: { acquireCount: { r: 74 } }, Collection: { acquireCount: { r: 74 } } } protocol:op_query 116ms
artin.representations command: count { count: "representations", query: { BadPrimes: { $all: [ "43" ] }, GaloisConjugates.Sign: 1, Hide: 0, Indicator: 1, Galois_nt: [ 11, 5 ] } } planSummary: IXSCAN { Hide: 1, Galois_nt: 1 } keyUpdates:0 writeConflicts:0 numYields:78 reslen:62 locks:{ Global: { acquireCount: { r: 158 } }, Database: { acquireCount: { r: 79 } }, Collection: { acquireCount: { r: 79 } } } protocol:op_query 360ms
artin.representations command: count { count: "representations", query: { BadPrimes: { $all: [ "43" ] }, GaloisConjugates.Sign: 1, Hide: 0, Indicator: 1, Galois_nt: [ 11, 5 ] } } planSummary: IXSCAN { Hide: 1, Galois_nt: 1 } keyUpdates:0 writeConflicts:0 numYields:84 reslen:62 locks:{ Global: { acquireCount: { r: 170 } }, Database: { acquireCount: { r: 85 } }, Collection: { acquireCount: { r: 85 } } } protocol:op_query 467ms
artin.representations command: count { count: "representations", query: { BadPrimes: { $all: [ "43" ] }, GaloisConjugates.Sign: 1, Hide: 0, Indicator: 1, Galois_nt: [ 11, 5 ] } } planSummary: IXSCAN { Hide: 1, Galois_nt: 1 } keyUpdates:0 writeConflicts:0 numYields:85 reslen:62 locks:{ Global: { acquireCount: { r: 172 } }, Database: { acquireCount: { r: 86 } }, Collection: { acquireCount: { r: 86 } } } protocol:op_query 560ms
jwj61 commented 7 years ago

Added index for BadPrimes to beta

edgarcosta commented 6 years ago

Thanks. Did you also add the index in the cloud?

jwj61 commented 6 years ago

No. I am not sure if I have access to the cloud. If I do, I don't know how to access it.

AndrewVSutherland commented 6 years ago

I just updated the database on the cloud, which automatically adds the indexes, the BadPrimes index is there now. In general I think adding individual indexes to collections on the cloud is a bad idea; unless there is a good reason not to, its safer to just run the standard update script.

edgarcosta commented 6 years ago

Sounds good. The issue can then be closed.

On Sep 14, 2017 13:07, "Andrew Sutherland" notifications@github.com wrote:

I just updated the database on the cloud, which automatically adds the indexes, the BadPrimes index is there now. In general I think adding individual indexes to collections on the cloud is a bad idea; unless there is a good reason not to, its safer to just run the standard update script.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/LMFDB/lmfdb-inventory/issues/64#issuecomment-329547337, or mute the thread https://github.com/notifications/unsubscribe-auth/AATtBuumlxcLYQglegFka2mqWgdkmZwUks5siV1JgaJpZM4PMY0t .