you may try db.executesql("""SELECT * FROM my_large_table""")Richard On Mon, Mar 16, 2015 at 4:50 PM, Richard Vézina <ml.richard.vez...@gmail.com > wrote: > Depends also what is you model definition, particularly what represent > are... since they sometimes implies "subquery"... > > Richard > > On Mon, Mar 16, 2015 at 4:49 PM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> I guess it depends of what in your table... >> >> But 1 million it is alot of records, why you need them all together? >> >> Richard >> >> On Mon, Mar 16, 2015 at 4:47 PM, LoveWeb2py <atayloru...@gmail.com> >> wrote: >> >>> I'm trying to select a SQL Table that has 1 million + records. >>> >>> my_table = db(db.my_large_table.id>0).select() >>> >>> My python thread hangs and eventually I have to kill it (otherwise it >>> takes forever). Is there a more efficient way to make the query or is this >>> a limitation for web2py? >>> >>> -- >>> 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. >>> >> >> > -- 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.
