Hello all! So i'm using web2py to allow users to use a form to query a database. This is all done with DAL, SQLFORM.factory, and the results displayed using SQLFORM.grid...
right now, after the form submits, i set the variables (session.name = form.vars.name) and create a query. This query is first set as db.Table.ID > 0 , and then using "query &= db.Table.name == session.name" i narrow results down based on whatever the user puts into the form. none of the 7 inputs are required, so the query code checks if the user filled out a field and then does the "query &= ..." . this is proving to take VERY long since the database is huge and im guessing it preloads all the "IDs" and then filters them out. is there a way to speed up this processing? i'm currently using lazytables since theres an option to choose between a few databases in the form. Thank you -- 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.
