core icon indicating copy to clipboard operation
core copied to clipboard

Published 20 hours ago • verified publisher icon MetaModels

Database Indexe

Open stefanheimes opened this issue 11 years ago • 4 comments

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.

stefanheimes avatar Jan 30 '14 10:01 stefanheimes

Can you specify which indices are most common?

discordier avatar Jul 23 '14 11:07 discordier

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

stefanheimes avatar Jul 24 '14 20:07 stefanheimes

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 avatar May 25 '21 20:05 zonky2

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

zonky2 avatar Jan 07 '23 16:01 zonky2