Hi all,
I got a collection for companies and one for persons. A company may have lots of persons and
a person may have lots of companies (in fact, most persons only have one company related).
When I search for all persons whose names start with "sc", my XPath-Query looks like this:
"/Person[starts-with('sc')]" on the collection "/db/person". In the display of the results
I also need the companies, in a form like this:
Company "idontcare AG"
- Person "schuster"
- Person "schulz"
Company "whatever AG"
- Person "schuber"
- Person "scholl"
Ok, I got all person-data from that query, but to retrieve the company-name (and some other
informations from the companies as well) I take the related companyID out of the person-document,
which is in fact a Xindice-ID of a company. Then I load every single company by ID, wich takes
a lot of time. I tried to create one very big query with all IDs in it, but it didn't work.
Same Problem when I search for a company - then I have to load every single person by it's
ID. Depending on the size of the database you need nearly as many queries as you got search-results
from the first query - in my case there are often more than 700 queries for only one search...
Is there any Sollution to make that far more performant?
I'm using a 1.1b2 cvs-build from 2003-10-06, embedded.
Greetings,
Christian Schuster
|