[prev in list] [next in list] [prev in thread] [next in thread] 

List:       monetdb-users
Subject:    Re: [MonetDB-users] hold cursors over commit in JDBC
From:       Fabian Groffen <Fabian.Groffen () cwi ! nl>
Date:       2012-06-12 7:55:55
Message-ID: 20120612075555.GH46833 () cwi ! nl
[Download RAW message or body]

[Attachment #2 (multipart/signed)]


On 12-06-2012 00:13:14 -0700, Majid Azimi wrote:
> Let me ask it this way:  
> 
> How can we configure driver so it doesn't fetch all records at one time.

That's the default mode of operation.  It fetches some amount, if you
think that's still too big, use Connection.setFetchSize().

> for example 100 records per each fetch, So the application server doesn't get OutOfMemoryException.

The default is 250, and it uses weak references to get the best.  Make
sure you use forward-only cursors if you move forward only (the
default), as it allows the driver to cleanup as soon as data has been
read.

Fabian

["signature.asc" (application/pgp-signature)]

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/

_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users


[prev in list] [next in list] [prev in thread] [next in thread]