search

MetaModels / core

MetaModels Core Module
GNU Lesser General Public License v3.0
96 stars 42 forks source link

Database Indexe #372

Open stefanheimes opened 10 years ago

stefanheimes commented 10 years ago

MetaModels must set indexe for the database. Based on the attribute or filter. I have a SQL query with 60.000 ids. Without indexe it take ~6 seconds if i set Indexe on the fileds it take only 0.063 seconds.

So i think we need a system for this.

discordier commented 10 years ago

Can you specify which indices are most common?

stefanheimes commented 10 years ago

Basically all attributes or fields where a filter is set for. But i have to take a look in one of our project.

zonky2 commented 3 years ago

MM call 25.05.2021:

es gibt aktuell keine Konfigurationsmöglichkeit, um z.B. für einen Select oder Textfilter einen Index auf der "Nutztabelle" zu setzzen

zonky2 commented 1 year ago

siehe auch https://metamodels.readthedocs.io/de/latest/cookbook/tips/speed-up-backend-list.html