You will have to operate with directly with Village or possibly straight
jdbc to process a large query result like this. There is an example
class o.a.t.util.db.LargeSelect that might be useful in this effort.
You need to make sure your jdbc driver is going to cooperate as well.
For example, I have been told, but have not verified that the mm Mysql
driver will load the entire result set into memory anyway, so the fact
that Peers wrap these results in Objects would not be the complete
problem.
John McNally
David Meaker wrote:
>
> I have a requirement to process a set of 200,000 records in a batch process.
> Using peers I get an out of memory error when I doSelect(). I assume a
> 200,000 element vector is created which stretches the resources on this
> machine I am using. Can one use peers to do this or should I be digging
> into Village.
>
> thanks in advance.
>
> Dave Meaker
>
> ----------------------------------------------------------------
> The information transmitted is intended only for the person or entity to
> which it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of, or
> taking of any action in reliance upon, this information by persons or
> entities other than the intended recipient is prohibited. If you received
> this in error, please contact the sender and delete the material from any
> computer.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
