Hi,

I made a lot of tests now and the inserts are much faster. I found out that the database was not optimized. When I optimize the DB before calling the inserts or deletes, they execute very fast.

But I have another problem now when I optimize the DB in Java code. I try to insert the new nodes in chunks of 8000 nodes per command. As I already said: I have to insert a lot of nodes (more than 100000) and I think that would be too much for one XQuery command (???). So what I basically do now is this:

1. Gathering all the information I need for the insert commands
2. Creating a loop in Java that executes the insert commands every 8000th iteration
3. After each iteration, I try to optimize the database with this Java command: new XQuery("db:optimize('DB_Name', false())").execute(context);

The problem is that - when the second iteration of the loop tries to insert the next 8000 nodes - I get this exception "TM: no context value bound". I add the complete stack trace below. I already tried to create a new context, but that didn't work. What could be the problem?

Thank you very much for your help in advance!
Michael


Here the complete stack trace:


org.basex.core.BaseXException: Stopped at ., 1/5847730:
[XPDY0002] TM: no context value bound.
    at org.basex.core.Command.execute(Command.java:94)
    at org.basex.core.Command.execute(Command.java:116)
    at actions.basex.Test.run(Test.java:256)    --> This line contains the insert command: new XQuery([INSERT_QUERY]).execute(context);
    at actions.basex.Test.<init>(Test.java:50)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at main.Main.main(Main.java:44)
Caused by: org.basex.query.QueryException: TM: no context value bound.
    at org.basex.query.QueryError.get(QueryError.java:1392)
    at org.basex.query.expr.path.Step.checkNode(Step.java:227)
    at org.basex.query.expr.path.IterStep$1.next(IterStep.java:37)
    at org.basex.query.expr.path.CachedPath.iter(CachedPath.java:72)
    at org.basex.query.expr.path.CachedPath.nodeIter(CachedPath.java:51)
    at org.basex.query.expr.path.AxisPath.iter(AxisPath.java:69)
    at org.basex.query.expr.path.AxisPath.iter(AxisPath.java:40)
    at org.basex.query.expr.constr.Constr.add(Constr.java:70)
    at org.basex.query.expr.constr.CElem.item(CElem.java:93)
    at org.basex.query.expr.constr.CElem.item(CElem.java:1)
    at org.basex.query.expr.ParseExpr.iter(ParseExpr.java:48)
    at org.basex.query.expr.constr.Constr.add(Constr.java:70)
    at org.basex.query.expr.constr.CElem.item(CElem.java:93)
    at org.basex.query.expr.constr.CElem.item(CElem.java:1)
    at org.basex.query.expr.ParseExpr.iter(ParseExpr.java:48)
    at org.basex.query.expr.List$1.iter(List.java:151)
    at org.basex.query.expr.List$1.next(List.java:119)
    at org.basex.query.QueryContext.next(QueryContext.java:397)
    at org.basex.query.expr.constr.Constr.add(Constr.java:71)
    at org.basex.query.up.expr.Insert.item(Insert.java:55)
    at org.basex.query.expr.ParseExpr.iter(ParseExpr.java:48)
    at org.basex.query.expr.List$1.iter(List.java:151)
    at org.basex.query.expr.List$1.size(List.java:141)
    at org.basex.query.scope.MainModule.cache(MainModule.java:99)
    at org.basex.query.QueryContext.iter(QueryContext.java:333)
    at org.basex.query.QueryProcessor.iter(QueryProcessor.java:90)
    at org.basex.core.cmd.AQuery.query(AQuery.java:100)
    at org.basex.core.cmd.XQuery.run(XQuery.java:22)
    at org.basex.core.Command.run(Command.java:257)
    at org.basex.core.Command.execute(Command.java:93)
    ... 8 more

---