Spatial indexes: test and benchmarks spatial index load on db (on read and write)

chairemobilite / transition

Transition is a modern new approach to transit planning. It's a web application to model, simulate and plan public transit and alternative transportation.

http://transition.city

MIT License

21 stars 13 forks source link

Spatial indexes: test and benchmarks spatial index load on db (on read and write) #84

Open kaligrafy opened 3 years ago

kaligrafy commented 3 years ago

Should we keep projects in separate schema to reduce index sizes and increase query speed or would it be fast enough to keep everything in the same table? We need more spatial index benchmarks.

tahini commented 2 years ago

Right now, there doesn't appear to be indexes in the database for the geographies. Is that right? Investigate... It would seem the indexing is done only in javascript.

kaligrafy commented 2 years ago

There are indexes on tr_od_trips, and for now it is the only table that could include large amount of data.

kaligrafy commented 2 years ago

nodes are currently indexed on the fly in javascript (client)