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 <[email protected] > 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 <[email protected]> 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 [email protected]. >> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
