How can I speed up a faceted search using advsearch on collections (300k records)?

[halftrainedharry]

I never used the extra customExtra and as it isn’t an open-source extra, I can’t look at the code to see how it actually works.

The easiest way is probably to use MIGXdb (that is part of the MIGX extra).
Are you still using MODX 2.x? (I don’t know if the package manager in MIGX already works in MODX 3).
Maybe take a look at this video:

ExtraBuilder + MIGX CMP Walkthrough Video

Hey all, I took a stab at recording a walkthrough on using these two extras together to create some custom table and manager page goodness. Hope it helps someone. Thanks to Bruno and Jared for the great tools they have built for us. Link to the MIGX TV types mentioned in the video:

---

By the way, for your “date” TV: Wouldn’t it be more practical to search for a timespan than to have an input field and search for matching strings with the LIKE operator?