Looking for consulting expert (up to $200) to improve query all records speed performance

Vagan

Hi folks!

I'm looking for someone who can take a brief look at our database (35k requests, but with many fields, and part of them is arrays), and give some working recommendations about how we can improve query all records requests speed.

Our query all records requests include many "overlaps" and "in" filters (10 filters), so it could be from 1 to 3 seconds to process the request. Is this a way to multiplicity improve it, to 0,1-0,25 sec? GIN Index doesn't fit us, because many of the filters are "OVERLAPS" operators.

If you have any ideas please message me at vagan.abelyan@gmail.com

Willing to pay up to $200 for advice will perform.

Pawel Magdanski

Hi are you making all 10 filters in the same query? If you have a some filters that are cutting out a big chunk of records and are light it might beneficial to do the more heavy ones on the initially reduced list.

Other thinkg would be to try to change some of this heavy filters, by introducing some supporting columns with categories etc, but this kind of actions depend on case.

Ioannis Roungeris

Hey, please schedule a free call here to discuss