Hello,
we have performance issues with the combined search (Metadata + Fulltext).
A search lasts about 30-60 seconds, even if the systems have good performance.
Is there a better way than submitting the Query in this way (see sample below)?
- eg. is it possible to search first with Metadata only and then search with fulltext within the Metadata search Result?
The Metadata search brings usaly only about 50 - 150 items.
Thanks for any hint,
- Thomas Koch
PS.: this is an Search Example:
sl_XML_Query->Text = "<?xml version=\"1.0\" encoding=\"utf-8\" ?>"
"<search>"
"<queries>"
"<query>"
"<from>"
"<itemtype name=\"PDMS.WoWis:Dokumente\" />"
"</from>"
"<select>"
"<property name=\"ixos.dms:Id\" />"
"</select>"
"<where>"
"<and>"
"<like>"
"<property name=\"PDMS.WoWis:dokBzg\" />"
"<literal value=\"%[#dokBzg#]%\" datatype=\"String\" />"
"</like>"
"</and>"
"</where>"
"<fulltext>"
"<fulltext-id name=\"[#Fulltext_ID#]\" />"
"<fulltextquery>"
"<word value=\"(^.*?[#Volltext#].*?$)\">"
"<wordprop name=\"QueryType\" value=\"RegEx\" />"
"</word>"
"</fulltextquery>"
"</fulltext>"
"</query>"
"</queries>"
"</search>";