Maurice Ling wrote:

>
> It is not about the join, it is about the amount of data returned. I can
> do a select * from X table in isql.
>
> cursor.execute("select * from X")
> data = cursor.fetchall()
>
> gives me a vm_allocate() error

Can't you use a loop over fetchone() or itermap() ?

best regards
Pavel Cisar