Hi Karl, > The normalization resulting from the use of the Actors > section makes it difficult to search. For example, to > perform a search against part of the body section that is > constrained to elements that are associated with a particular > actor, you cannot simply use the name of the actor directly. > You must search the Actors section for the actor name, find > the corresponding ID, then perform your search against the > body using your criteria and ensuring that the results are > constrained to those that reference that ID.
As Kelly also suggested, you can do calculations at loading time, and wrap optimized information together with the original data in some convenient element. But I am not sure that would make really sense in this particular case. It makes perfect sense to have the Actors normalized and referenced by ID. And you already described the right approach to add a constraint for a particular Actor: just lookup the ID first and use that to filter out results that do not reference that ID. In other words, just use two search calls to make this work. There is nothing against that. If indices are setup properly, you should still get results in the subsecond range.. :-) Kind regards, Geert Drs. G.P.H. Josten Consultant http://www.daidalos.nl/ Daidalos BV Source of Innovation Hoekeindsehof 1-4 2665 JZ Bleiswijk Tel.: +31 (0) 10 850 1200 Fax: +31 (0) 10 850 1199 http://www.daidalos.nl/ KvK 27164984 De informatie - verzonden in of met dit emailbericht - is afkomstig van Daidalos BV en is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht onbedoeld hebt ontvangen, verzoeken wij u het te verwijderen. Aan dit bericht kunnen geen rechten worden ontleend. _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
