Well, I'll try once more. It has been observed in http://marc.theaimsgroup.com/?l=xindice-users&m=102155822118842&w=2 that owing to a bug (?) in xindice 1.0, under some or all circumstances, creating the index after adding documents does not work right. If you observed no difference in query time with and without the index, you probably need to delete the collection, create the index, and then add the documents again. In the cited message, query times dropped from 3 min. to 30ms for a collection with 100,000 documents (or 120ms for 500,000 documents).
Jeff ----- Original Message ----- From: "Matthew Van Horn" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, November 11, 2002 7:08 PM Subject: Re: Performance question (Am I doing something wrong?) > On Tuesday, November 12, 2002, at 11:47 AM, Jeff Greif wrote: > > While this explanation may help for Beni's issue, my documents _are_ > fairly small with a minimum of duplicate elements, yet my queries are > taking 3 -4 *minutes*. I finally broke down and tried this > programmatically instead of from command line. The following program > runs the query in about 3:30. However, thinking that the first query > might be untypically slow, I tried again and had it run a few slightly > different queries in one run, and they all take that long. Does anyone > know where I can start to look for possible causes of this, and ways to > improve?
