I m nt able to login to communicator...can u cm to my gmail id [email protected] Soumadri Roy 68313 | HCU INS TIMES | Bangalore, India Phone: +91.67805558 Mobile: +91.99868.32356 | [email protected] ________________________________________ From: [email protected] [[email protected]] On Behalf Of Frank Sanders [[email protected]] Sent: Monday, February 16, 2009 20:07 To: General Mark Logic Developer Discussion Cc: Joydeep_Sinha; Vivek_Nagasundara; Phanish_T Subject: RE: [MarkLogic Dev General] Improve search performance on MarkLogic
Since you’re only interested in searching within the ShipName element, I’d suggest using an element-word-query as opposed to a word query. Additionally I’d suggest using the fully qualified XPath for ShipName instead of //ShipName. -fs From: [email protected] [mailto:[email protected]] On Behalf Of Soumadri_Roy Sent: Monday, February 16, 2009 8:16 AM To: [email protected] Cc: Phanish_T; Vivek_Nagasundara; Joydeep_Sinha Subject: [MarkLogic Dev General] Improve search performance on MarkLogic Hi, Searching for data from MarkLogic is giving high execution time as compared to SQL Server 2005. I have used MLSQL to pull records(830 records) from SQL Server 2005 and put into MarkLogic. Following is a snapshot of the xml in MarkLogic. <sql:result xmlns:sql="http://xqdev.com/sql";> <sql:meta /> <sql:tuple> <OrderID>10248</OrderID> <CustomerID>VINET</CustomerID> <EmployeeID>5</EmployeeID> <OrderDate>1996-07-04 00:00:00.0</OrderDate> <RequiredDate>1996-08-01 00:00:00.0</RequiredDate> <ShippedDate>1996-07-16 00:00:00.0</ShippedDate> <ShipVia>3</ShipVia> <Freight>32.3800</Freight> <ShipName>Vins et alcools Chevalier</ShipName> <ShipAddress>59 rue de l'Abbaye</ShipAddress> <ShipCity>Reims</ShipCity> <ShipRegion null="true" /> <ShipPostalCode>51100</ShipPostalCode> <ShipCountry>France</ShipCountry> </sql:tuple> -<http://172.19.81.28:8000/cq/eval.xqy?iefix.txt> <sql:tuple> <OrderID>10249</OrderID> <CustomerID>TOMSP</CustomerID> <EmployeeID>6</EmployeeID> <OrderDate>1996-07-05 00:00:00.0</OrderDate> <RequiredDate>1996-08-16 00:00:00.0</RequiredDate> <ShippedDate>1996-07-10 00:00:00.0</ShippedDate> <ShipVia>1</ShipVia> <Freight>11.6100</Freight> <ShipName>Toms Spezialitäten</ShipName> <ShipAddress>Luisenstr. 48</ShipAddress> <ShipCity>Münster</ShipCity> <ShipRegion null="true" /> <ShipPostalCode>44087</ShipPostalCode> <ShipCountry>Germany</ShipCountry> </sql:tuple> </sql:result> I am using the query cts:search(//ShipName,cts:word-query("Vins")) . Similarly for SQL Server, I have enabled Full-text search and executed the query SELECT * FROM Orders WHERE CONTAINS(ShipName,'Vins') . On Marklogic I have only enabled “Basic Stemmed Search” and “Word Searches”. Now when I executed both of these queries, I get the following execution times. MarkLogic - 31ms(1st Hit) 15ms(Subsequent Hits) SQL - 45secs(1st Hit) 1ms(Subsequent Hits) The subsequent hits in case of SQL Server is faster than MarkLogic search. Is MarkLogic really superior to SQL Server 2005 in terms of full text search? If so, please provide me the solution to it. If there is an optimized combination of index settings, please provide that too. Thanks and Regards Soumadri Roy Mobile: 09986832356 _____ DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. DISCLAIMER: This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. _______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
