Hello, We have been testing MarkLogic 8 downloaded from your website for a POC.
Our environment is very straight forward. A single VM (windows 7 Enterprise - 64bit) with 16GM RAM and 2 Intel (E5-2690 v2) 3GHz processors. We have around 4 SQL tables that we modeled in Json format so each row ends up becoming a document, and here are some of the stats: Patient : 8 fields / 20,924 documents PatientAddress: 5 fields / 36,193 documents Claim: less than 30 fields / 335,349 documents ClaimDiagnosis: 2 fields / 8,676 documents We created element range index for all the fields, and created 4 views that each represent a SQL table. Then we were able to use SQL to query the data and get the result in the query console. But the performance is not nearly as what we expected, we thought it would work faster than SQL environment. A simple query like the one below took 30 seconds to run, and the same query took 3 seconds to run with a larger data set in a SQL environment with 6GB memory and 4 processors. select c.Patientid, ClaimNumber, FirstName, LastName, sum (PharmacyTotalCost) as PharmacyTotalCost from claim c inner join patient p on c.patientid = p.patientid left outer join patientaddress a on p.patientid = a.patientid where a.[State] = 'LA' group by c.PatientId, ClaimNumber, FirstName, LastName order by SUM(PharmacyTotalCost) desc limit 10 We also tested out the connection between MarkLogic and Tableau 9 trial version through MarkLogic 64 bit ODBC connector on the same VM. The connection is not stable, got lost very frequently, and sometimes it won't stop running for 20 minutes after adding one dimension and one simple measure the columns and rows shelves. We are under a very tight timeline and have to report our findings back to our client within 24 hours. With the current performance, we will not be able to recommend any MarkLogic product to our client. Please help us if there is anything that we could do to improve the SQL query performance and data connectivity between Tableau and MarkLogic. Also, for the query as the simple example above, is there any XQuery or Javascript Query that we can use that could produce the similar results? We cannot find any documented examples. Any help will be really appreciated! Thank you very much, Cynthia Jiang RDA Corpration
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
