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.

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

Indexes for Date Columns #34

Closed
dmlb2000 opened this issue Jun 6, 2017 · 1 comment
Closed

Indexes for Date Columns #34

dmlb2000 opened this issue Jun 6, 2017 · 1 comment

Comments

@dmlb2000
Copy link
Member

dmlb2000 commented Jun 6, 2017

Pacifica Metadata version

Master

Pacifica Core Software versions

Master

Platform Details

Any

Scenario:

Seems we'll need to search quickly on date ranges for files. We need to add indexes for the updated created and deleted columns.

Steps to Reproduce:

Try to search for files between two dates.

Expected Result:

should come back reasonably quickly

Actual Result:

Does a complete table scan of the files metadata.
@dmlb2000 dmlb2000 mentioned this issue Jun 6, 2017
Merged
3 tasks
@dmlb2000
Copy link
Member Author

dmlb2000 commented Jun 6, 2017

This is fixed now...

@dmlb2000 dmlb2000 closed this as completed Jun 6, 2017
@bonilla-pnnl bonilla-pnnl mentioned this issue Jan 16, 2020
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@dmlb2000