Ok, found the reason to why the query below didn't work, I had failed to include a "group by"-clause.
However, that doen't solve the problem. If I get lots of hits when doing a search it still takes a long time to execute. What I would like to do is to move the limititation from the Slide server to the DB-server (where it really belong). As I understand it the keyword "limit" isn't part of SQL-standard (Orcale for one doen't implement it) so I guess that this is difficult do in generic terms. This is, however, important for us as we need the performance so which class/classes would I have to override in order to modify the behaviour of the search method? Is this recommended at all? Or should we try to limit the client so we can't do to wide searches? /Pontus > -----Original Message----- > From: Pontus Strand [mailto:[EMAIL PROTECTED] > Sent: Friday, January 14, 2005 2:51 PM > To: 'Slide Users Mailing List' > Subject: RE: Slide search performance issues > > > A quick follow-up, when working with large number of files > the number of > hits when doing a search could be large. As I understand it, > it is possible > to limit the number of responses by using the DAV:limit XML > element from the > DASL specification. However, the specification also states > that the server > may disregard the requested limit. So my questions are: Does > Slide support > DAV:limit? And will it work when using the > "use-rdbms-expression-factory" > parameter? And, finally, am I using correct syntax in the > example below? > > <D:searchrequest xmlns:D =\"DAV:\"> > <D:basicsearch> > <D:select> > <D:allprop/> > </D:select> > <D:from> > <D:scope> > <D:href></D:href> > </D:scope> > </D:from> > <D:where> > <D:and> > <D:eq><D:prop><D:fileextension/></D:prop> > <D:literal>xml</D:literal></D:eq> > </D:and> > </D:where> > <D:limit> > <D:nresults> > 10 > </D:nresults> > </D:limit> > </D:basicsearch> > </D:searchrequest> > > The reason for my questions is that I can't get it to work > and I can't find > any references to this. Is there perhaps another way to limit > the number of > search hits? > > Regards, > Pontus > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
