We implemented the following changes:
- Cache single word and subject searches - we added Memcached to store some searches. A cron job is reloading the subject searches into the cache on a regular basis.
- Pagination on Search Result page - previously we were displaying all of the search results on the same page. This caused a long page render time which made the slow search even slower. We are now displaying 10 items on each page. Books are displayed first since most users are looking for books. When possible, we use the cached search results to return the next page.
- Improved SQL performance - we tweaked the SQL used for the queries to optimize them.
All of these changes are no-brainers, but have vastly improved search.
Follow OpenStax CNX on Twitter
Visit OpenStax CNX Facebook Page
Learn computer science. It's extraordinarily helpful. I like recommending learning economics as well so they think in terms of business, they have rational frameworks for looking at the world, but yeah, computer science is an amazing way to get into, even if you want to be CEO, having a tech background is helpful.
ReplyDeleteoffer code dsw
We did little to improve the speed before the release because of time constraints. It was decided that we needed to revisit it this summer to get things in great shape for the Fall semester.
ReplyDeleteOplaza Club
These changes are actually good in making sure that your website is doing fine amidst all the competitions. Something that keeps you unique as compared to other sites such as https://www.recruiter.com/i/8-reasons-why-new-graduates-lose-out-on-jobs/.
ReplyDeletehello use this link
ReplyDeleteDr Shetty
Dr Devicharan Shetty