I have a table which currently contains 10m+ records (local government spending in www.appgov.org). A native SQL count(*) will take 3-5 secs but reading all the records like this via the DAL will result in the system hanging. I try not to read too many of these records in any one online transaction by allowing only selections and calculating subtotals offline. I also create MySQL indexes outside of Web2py to speed things up where necessary. Of course I also can't ever say db.laspend.id>0 in the Database Admin facility either!
> > -- 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.
