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

Removing location textual fields indices from tables of db_views.py file #2676

Open
atalyaalon opened this issue Jun 25, 2024 · 2 comments
Open
Assignees
Milestone

Comments

@atalyaalon
Copy link
Collaborator

atalyaalon commented Jun 25, 2024

That's for the next milestone, but I want to keep documentation of this issue as we spoke about it in our last meeting

We can first:

  • Remove indices and make sure it does not harm the cache performance
    This includes removing text fields of yishuv_name and street1_hebrew and street2_hebrew and road_segment_name from the indices of the 5 DB tables markers_hebrew, involved_markers_hebrew, vehicles_hebrew, involved_hebrew if exist in them

And then:

  • discuss creating smaller tables (idea that was discussed in the past and was not implemented yet)
@ziv17
Copy link
Collaborator

ziv17 commented Aug 30, 2024

Hi @atalyaalon
We want to add the numeric indexes if they do not exist, right? (e.g. involved_markers_hebrew does not have street2 index.

@atalyaalon
Copy link
Collaborator Author

@ziv17 yes you are right.
And in table involved_markers_hebrew we also want to remove the street1_hebrew, street1_hebrew, accident_yishuv_name , road_segment_name, as you performed in this pr

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

No branches or pull requests

2 participants