Hallo Maurice,
it is know issue for all application and all framworks.
which database are you using ?
- my first attempt will be to try to add indexes in the post and answers
Table on the field author.
- secondly i will try to change this row
> row = db(db.post.author== auth.user.id).select(db.post.id, db.post.message
> , orderby=~db.post.id, limitby=(0,1)).first()
to this
>
> row = db(db.post.author== auth.user.id).select(db.post.id, db.post.message
> , orderby=~db.post.id).first()
limitby ist not needed in that case. it is just my opinion.
Am Mittwoch, 29. August 2018 13:35:56 UTC+2 schrieb Maurice Waka:
>
> I noticed that my form submit takes too long, almost 45 seconds sometimes.
> The more data I add to the database and I need to fetch it, the more longer
> it takes to submit.
> This is my code
>
> <div class="bottom_wrapper clearfix">
> <div class="message_input_wrapper">
> {{=form.custom.begin}}
> <textarea id="message_input" type="text"name="message"
> placeholder="Type your message here..."></textarea>
> <button>send</button>
> {{=form.custom.end}}
> </div>
> <div class="message_template">
> <li class="message">
> <div class="message-data-time" ></div>
> <div class="text_wrapper">
> <div class="text"></div>
> </div>
> </li>
> </div>
> </div>
>
> Controller function
>
> def c_function():
> form = SQLFORM(db.post).process()
> row = db(db.post.author== auth.user.id).select(db.post.id, db.post.
> message, orderby=~db.post.id, limitby=(0,1)).first()
> names = row.message if row else None
> db.answers.insert(quest=names, message=report())
> replies = db(db.answers.author == auth.user.id).select(db.answers.ALL
> )[-10:-1]
> return dict(form=form,names=names,replies=replies)
>
>
--
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.
