when trying in the shell, the shell itself got killed : >> In [4]: legacy_db(query).select() >> >> Killed >> root@rb:/home/www-data/web2py#
Even using executesql (but i can query sqlite directly) "step out apache": Does this mean stopping apache? Thank you a lot for your help 2016-08-03 22:35 GMT+02:00, Niphlod <niph...@gmail.com>: > a) step out apache as soon as you can > b) what if you do it in a shell ? > c) the only limit is the available memory > d) if you hit that limit, and you don't need update_record() and > delete_record(), you can save some with select(...cacheable=True) > e) even more can be saved with executesql(as_dict=True) > > On Saturday, July 30, 2016 at 10:14:10 AM UTC+2, goome wrote: >> >> Hello >> is there any size limit in DAL about query? >> i explain: >> i have a script that stop running. >> I thought it was a problem with modwsgi becouse i got the error message >> 'truncatet or oversize respoinse header' (so that i post this question : >> https://groups.google.com/forum/#!topic/web2py/CRsEWe_mmSc) >> but now i realized the problem raise even in the web2py shell, exactly >> when querying: >> This is from my pc: >> """ >> tabella = 'STK' >> In [3]: query = legacy_db[tabella] >> legacy_db(query).select() >> >> Out[5]: <Rows (32144)> >> "" >> >> this from the server, where the data in the db is are more: >> """In [1]: tabella = 'STK' >> >> In [2]: query =legacy_db[tabella] >> In [4]: legacy_db(query).select() >> >> Killed >> root@rb:/home/www-data/web2py# >> """ >> i still can query through 'executesql' : >> >> n [1]: rows = legacy_db.executesql("select * from STK") >> >> In [2]: len(rows) >> Out[2]: 155370 >> >> The insertion in the table, by means of DAL and a cronjob, still is >> working >> >> Any help? >> Thanks >> >> > > -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/nqUnVx62GE0/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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.
