Sorry for the slowness of the site over the last week. What caused the slowness was a change in how I collect and store keywords from listings. I am also now indexing the listings descriptions too. This caused the number of keywords that the database had to grow exponentially. It turns out that a little SQL optimization can go a long way in speeding things up.
I also started using a technology that I learned about and played with last year called memcached. It is a server that allows me to store database results in memory for a little while so that the database does not need to be re-searched as you page through the results, only when you perform the initial search.
Thank you everyone for your continued support as we grow TikiWade to be a better way to find and sell classifieds online.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment