You may try using iterselect() instead of select() if the issue is memory related.
The link to the book is below. http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=Using-an-iterator-based-select-for-lower-memory-use#Using-an-iterator-based-select-for-lower-memory-use On Thursday, August 4, 2016 at 10:35:13 AM UTC+3, goome wrote: > > 2016-08-04 1:08 GMT+02:00, Dave S <snide...@gmail.com <javascript:>>: > > > > > > On Wednesday, August 3, 2016 at 2:33:35 PM UTC-7, goome wrote: > >> > >> when trying in the shell, the shell itself got killed : > >> >> In [4]: legacy_db(query).select() > >> >> > >> >> Killed > >> >> root@rb:/home/www-data/web2py# > >> > >> > > Is that using web2py in a bash/python shell (i.,e., -M -S myapp) ? > yes, this one > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.