[ZODB-Dev] repoze.catalog.query very slow

2013-01-03 Thread Claudiu Saftoiu
Hello all, Am I doing something wrong with my queries, or is repoze.catalog.query very slow? I have a `Catalog` with ~320,000 objects and 17 `CatalogFieldIndex`es. All the objects are indexed and up to date. This is the query I ran (field names renamed): And(InRange('float_field', 0.01,

Re: [ZODB-Dev] repoze.catalog.query very slow

2013-01-03 Thread Jeff Shell
Dear gods, I hope you get an answer to this question, as I've noticed the same thing with very large indexes (using zc.catalog). I believe that at the root layers repoze.catalog is built around the same concepts and structures. When I tried to trace down the problems with a profiler, they all