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) ? Or in the web shell (admin app feature)? The latter is deprecated.
> Even using executesql > (but i can query sqlite directly) > "step out apache": Does this mean stopping apache? > > Probably just using the shell to avoid having apache doing things like killing the thread. > Thank you a lot for your help > > If you are using -S myapp, do you have top (on linux) or taskmgr (on windders) monitoring the system state? /dps > > > 2016-08-03 22:35 GMT+02:00, Niphlod <nip...@gmail.com <javascript:>>: > > 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+un...@googlegroups.com <javascript:>. > > 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.
