Skip to content
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.

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

Create Indexes on DateTime Fields on the Instance Model #2392

Closed
KipSigei opened this issue Mar 8, 2023 · 1 comment · Fixed by #2393
Closed

Create Indexes on DateTime Fields on the Instance Model #2392

KipSigei opened this issue Mar 8, 2023 · 1 comment · Fixed by #2393

Comments

@KipSigei
Copy link
Contributor

KipSigei commented Mar 8, 2023

Adding an index to the DateTimeFields on the Instance Model would improve performace when doing a sort on the logger instance table. This is because the logger_instance table has millions of records and currently without indexing the database performance is greatly impacted when a user does a sort operation with the date_modified field.

@alepietrobon
Copy link

@ukanga , @KipSigei suggested that for this to be tested, we might want to test it on a preview server with large scale, even if for a short time.
One way to achieve this would be to increase the RDS size for the Ona Data Stage server for a short period (a week), so we can create a duplicate of production (or something close to it) to check the impact of indexing on reads and writes.
Is this something you'd be ok with?

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

Successfully merging a pull request may close this issue.

2 participants