PymonetDB low level MAPI interface: Increase the return array size?

[krimp]

I'm using MonetDB Mar2018 release and the low level MAPI Python interface. When requesting data from MonetDB, only 100 records are returned. Executing the same query from the mclient returns 584 records. My code goes like this:

from pymonetdb import mapi mapiCon = mapi.Connection() mapiCon.connect( hostname="localhost", port=50000, username= and so on....) data = mapiCon.cmd(...myQuery...)

My question is: How does one change this 100 limit using the mapi interface?

[gijzelaerr]

this might be related to https://github.com/gijzelaerr/pymonetdb/issues/32. What is the Python code you use to retrieve your results?

[krimp]

The Python (Python 3.5) code is as stated in my opening issue:

from pymonetdb import mapi

mapiCon = mapi.Connection() mapiCon.connect( hostname="localhost", port=50000, username= and so on....) data = mapiCon.cmd("sSELECT .....")

[krimp]

The solution seems to be:
Constrain reply size to 1000 by mapiCon.cmd("Xreply_size 1000")

I.e: from pymonetdb import mapi mapiCon = mapi.Connection() mapiCon.connect( hostname="localhost", port=50000, username= and so on....) mapiCon.cmd("Xreply_size 1000") data = mapiCon.cmd(...myQuery...)

[gijzelaerr]

Sorry for the delay, only found time to look at this now. This is not really unexpected since this is how MAPI works. Still, I'll add a helper function.

[gijzelaerr]

there now is a map.connection.set_reply_size() helper.