is convex this bad or is it skill issue
is convex this bad or is it skill issue, why cant i stack indexes to filter rows down
5 Replies
Maybe neither 🙂 Can you say more about what you're trying to do?
use mutiple indexes with a search query for a basic cattegory, ordering, search filter
works fine and fast in sql
That sounds doable with a single index. There's some level of combining indexes possible with streams: https://www.convex.dev/components/aggregate#offset-based-pagination
But again, you may just be able to use one index. Would need an example to say for sure.
Like if you want to search on a field, and have category equal x, and order by some field, you can do that with a single index.
oh actually order with search is tricky
Streams might work for that, I haven't actually tried a search index with streams. But it looks to be supported.
Can you share an actual example query that you're trying to do with Convex? That'll help make this less abstract.
i excluded own