Status: New
Owner: ----
Labels: Type-Enhancement Priority-Medium
New issue 3619 by [email protected]: Performace of /api/search poor on
large deployments
https://code.google.com/p/reviewboard/issues/detail?id=3619
*** For customer support, please post to [email protected]
*** If you have a patch, please submit it to
http://reviews.reviewboard.org/
***
*** Do not post confidential information in this enhancement request!
What version are you running?
Reviewboard 2.0.3
What's the URL of the page this enhancement relates to, if any?
/api/search
Describe the enhancement and the motivation for it.
With over 100,000 review requests in our DB, text query of ReviewRequest
summary caused by
https://github.com/reviewboard/reviewboard/blob/556609d/reviewboard/webapi/resources/search.py#L75
takes a long time for very short strings.
We often see exceptions come in for "/api/search?q=d"
or "/api/search?q=r"; The user is typing slower than the 400ms ajaxDelay;
presumably they're still typing and want to search for something longer --
they won't even see this first request.
Depending on the deployment, this request can will block other requests
from processing, and potentially could trigger 500 responses.
Our deployment is apache mod_proxy to a gunicorn server that times out
after 120 seconds. The gunicorn timeout triggers a SIGABRT, which sends
admins unhandled exception for SystemExit(1).
Maybe could the search optimize to not search summary for very short
strings? (<2 or 3 characters)
Or maybe could /api/search leverage the search index if it is present?
What operating system are you using? What browser?
Any.
Please provide any additional information below.
We're using a MySql Database.
--
You received this message because this project is configured to send all
issue notifications to this address.
You may adjust your notification preferences at:
https://code.google.com/hosting/settings
--
You received this message because you are subscribed to the Google Groups
"reviewboard-issues" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/reviewboard-issues.
For more options, visit https://groups.google.com/d/optout.
