If your doing inserts only (not AdHoc queries ) then you can betch inserts using the Session.InsertContent( Content[] ) method with many files in a batch.
This is what the "put" command in the marklogic extension for xmlsh does. http://www.xmlsh.org/MarkLogicPut You can also do these multi-threaded, I've found I can achieve some significant performance improvements using both batch and multithreading. I've found I have to play with the settings sometimes to get it to work right or else timeouts can occur (too many threads, too many files, too big is not good, where "too many" is something that varies with content and server) ---------------------------------------- David A. Lee Senior Principal Software Engineer Epocrates, Inc. [email protected] <mailto:[email protected]> 812-482-5224 From: [email protected] [mailto:[email protected]] On Behalf Of sree lekha Sent: Thursday, September 02, 2010 6:00 PM To: General Mark Logic Developer Discussion Subject: Re: [MarkLogic Dev General] batch inserts/updates Hi, Is there a process using Xquery and xcc that we can do batch inserts . Just like the concept of prepared statement in Oracle ,Can we do something with Marklogic .I am getting the error : java.lang.UnsupportedOperationException: Multi-request transactions not yet supported at com.marklogic.xcc.impl.SessionImpl.setAutoCommit(SessionImpl.java:95) when I try to commit after say 100000 records . Thanks Sreelekha
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
