Removing location textual fields indices from tables of db_views.py file - Githubissues

data-for-change / anyway

ANYWAY - Car accidents map

http://www.anyway.co.il

MIT License

75 stars 242 forks source link

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

Open atalyaalon opened 1 week ago

atalyaalon commented 1 week ago

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)