On May 1, 2017, at 20:45, Eliot Kimber <[email protected]> wrote: > > Using ML 8 we have an application that relies on reverse queries. The overall > application is not performing as well as we need it to and our initial > attempts at profiling show that the reverse queries are taking most of the > time. We have about 120,000 separate reverse query documents.
What kind of reverse queries are they? Text? Geo? Simple? Complex? > The “Inside MarkLogic” document suggests that reverse queries, properly > indexed, should be quite fast. I have verified that we have the “fast reverse > queries” index turned on. > > My question: What should I look for that might be causing our reverse queries > to not be optimized? What are you doing with them? Looping against 1,000 documents? Sample code will help us all understand. How fast are they running exactly? How fast do you need them to run? > Are there any other ML settings or server configurations that might affect > reverse query performance? Are there particular query patterns that might be > suboptimal? Is there a way that I can confirm that the reverse queries are > performing as fast as possible? The xdmp:plan function is your friend. -jh- _______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
