Hi all, Has anybody implemented MarkLogic like SQL to create BI reports? What's the performance observed?
I have converted 2 tables from my MS SQL server to MarkLogic. The sample XML after converting to MarkLogic are: 1. dbo.SCDetails <dbo.SCDetails> <Id>117311</Id> <RegId>9669</RegId> <UserId>John.cashier</UserId> <ItemId></ItemId> <ItemServiceId>1023</ItemServiceId> <HuLobRelLosRelId>42</HuLobRelLosRelId> <RemInstitutionId></RemInstitutionId> <Barcode></Barcode> <CodeValue></CodeValue> <NameValue>ULTRASONIC THERAPY</NameValue> <Category>Physiotherapy</Category> <SubCategory></SubCategory> <Qty>1</Qty> <CostOriginal>3000.00</CostOriginal> <Cost>3000.00</Cost> <CostPayer>0.00</CostPayer> </dbo.SCDetails> 2. dbo. SCSBillRels <dbo.SCSBillRels> <Id>8073</Id> <SCDetailId>6670</SCDetailId> <BillId>3449</BillId> <CreatedOn>11/19/2013 9:04:16 PM</CreatedOn> <CreatedBy>Netty.Cashier-IPD</CreatedBy> <UpdateOn></UpdateOn> <UpdateBy></UpdateBy> <RecordStatus>1</RecordStatus> </dbo.SCSBillRels> I have followed the instruction in https://docs.marklogic.com/guide/sql/setup to create the required element range indexes and View for the 2 sets of XML above. When I run the SQL query as shown below, I noticed that the performance query from MarkLogic is too slow if compare to MS SQL. Is that normal??? Can anybody help to point out where I miss out or how to improve the performance? Any help is appreciated! SQL Query MarkLogic 8 as SQL (# records /time taken) SQL select count(*) from main.dboscdetails 206817/4.259S 206817 (<0s) select count(*) from main.dboscsbillrels 250202/0.827S 250202 (<0s) select count(*) from main.dboscdetails SCDetails left join main.dboscsbillrels as SCSBillRels on SCSBillRels.SCDetailId = SCDetails.Id - (Query Console: Exceed Time Limit) 294585 (RazorSQL: 1641.403s) 294585 (<0s) cheers, SC-Khoo
_______________________________________________ General mailing list [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
