New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

schema out of sync in public portal and MSK portal #469

Open

inodb opened this issue Mar 21, 2023 · 1 comment · May be fixed by cBioPortal/cbioportal#10432

Labels

Member

inodb commented Mar 21, 2023

Some optimizations were done in our production databases but not submitted to the migration sql

inodb added the enhancement label

Member

jjgao commented Mar 23, 2023

I added three indexes into our local database which improved performance:

ALTER TABLE sample ADD INDEX idx_SAMPLE_STABLE_ID (STABLE_ID), ALGORITHM=INPLACE;
ALTER TABLE patient ADD INDEX idx_PATIENT_STABLE_ID (STABLE_ID), ALGORITHM=INPLACE;
ALTER TABLE clinical_event_data ADD INDEX idx_data_prefix (VALUE(767)), ALGORITHM=INPLACE;

dippindots linked a pull request

that will close this issue

Add indexes to database scheme cBioPortal/cbioportal#10432

Open

JREastonMarks transferred this issue from cBioPortal/cbioportal

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment