Re: [web2py] max size table that DAL can handle?

you may try db.executesql("""SELECT * FROM my_large_table""") Richard On Mon, Mar 16, 2015 at 4:50 PM, Richard Vézina 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

Re: [web2py] max size table that DAL can handle?

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 wrote: > I guess it depends of what in your table... > > But 1 million it is alot of records, why you need them all to

Re: [web2py] max size table that DAL can handle?

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

[web2py] max size table that DAL can handle?

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: