Thank you. Am working on it. On Mon, 11 Jun 2018, 22:29 Anthony <[email protected]> wrote:
> Below is the start of the controller code, containing several hundred >> lines: >> > > Hard to know what's going on without the code. Consider profiling the > code, or simply pick some spots you think might be taking long and return > early to see if things speed up. > > >> form = SQLFORM(Post, formstyle='table3cols',) >> if form.process().accepted: >> pass >> > > No need for the "if" or the ".accepted" here. Just do: > > form = SQLFORM(Post, formstyle='table3cols').process() > > >> messagev = '' >> for r in db(db.post.author == auth.user.id).select(db.post.ALL): >> messagev = r.message >> > > There is no reason to select the entire table and loop over it -- > ultimately, you simply end up with the message from the last record. > Replace the above with: > > row = db(db.post.author == auth.user.id).select(db.post.id, db.post. > message, > orderby=~db.post.id, > limitby=(0, 1)).first() > > messagev = row.message if row else None > > At the limitby(0,2) am using the js code below to obtain the string for >> the q, and a. >> > > Again, no reason to select the last two records if you end up using only > the last record in your code. > > Anthony > > -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/O6CxDRViyNA/unsubscribe. > To unsubscribe from this group and all its topics, 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.
