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