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 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.
