Prev: fsolve, complex number. Optimizer appears to be converging toa point which is not a root. Norm of relative change in X is less than max(options.TolX^2,eps)but sum-of-squares of function values is greater than or equal to sqrt(options.TolFun) Try ag
Next: Is there a Matlab derivative calculator like Wolfram?
From: Gerald Corzo on 2 Dec 2009 11:44
I am trying to insert big chunks of data, and I see that the fastinsert is really slow. Even now I received this message:

java.lang.OutOfMemoryError: Java heap space
at java.io.BufferedWriter.<init>(Unknown Source)
at java.io.BufferedWriter.<init>(Unknown Source)
at java.io.PrintWriter.<init>(Unknown Source)
at com.mathworks.jmi.OpaqueJavaInterface.getExceptionMessage(OpaqueJavaInterface.java:1313)
??? Failed to retrieve Exception Message

Does anyone know how to improve the fast insert. Some parameter that can help in sending it in series and not waiting to send the data. My autocommit is on, so I expected to dont store the process in the memory.

On the other hand, if no solution is possible, how can I calculate the maximum number of records I can try to insert at once. And if the exact number is not possible, how can I make it do the process in serial and not wait till he tries to keep al in memory (without needing to iterate my code one by one).

Any info is appreciated.
From: K E on 18 Dec 2009 13:06

> On the other hand, if no solution is possible, how can I calculate the maximum number of records I can try to insert at once. And if the exact number is not possible, how can I make it do the process in serial and not wait till he tries to keep al in memory (without needing to iterate my code one by one).

Sorry no solution, but I am having the same problem when I try to read in data from a database. I keep reducing the number of records requested and it keeps crashing,

java.lang.OutOfMemoryError: Java heap space

So it would be nice to have a way to know exactly how many records I should request.
From: Oleg Komarov on 18 Dec 2009 13:19
> > On the other hand, if no solution is possible, how can I calculate the maximum number of records I can try to insert at once. And if the exact number is not possible, how can I make it do the process in serial and not wait till he tries to keep al in memory (without needing to iterate my code one by one).
>
> Sorry no solution, but I am having the same problem when I try to read in data from a database. I keep reducing the number of records requested and it keeps crashing,
>
> java.lang.OutOfMemoryError: Java heap space
>
> So it would be nice to have a way to know exactly how many records I should request.

I'm really interested in this subject too. If somebody from TMW can help...

fastinsert 'is known' to be slow...I usually write data to .txt in delimited fmt and import it with the tools suplpied with the database software. Proved to be faster.
 | 
Pages: 1
Prev: fsolve, complex number. Optimizer appears to be converging toa point which is not a root. Norm of relative change in X is less than max(options.TolX^2,eps)but sum-of-squares of function values is greater than or equal to sqrt(options.TolFun) Try ag
Next: Is there a Matlab derivative calculator like Wolfram?