Faster search results
 

hey guys,

I have a bit of a beginner inquiry, I have a search that goes on on my site porntubehunters dot com and I am trying to increase the speed that the search results appear in.

For instance, when I search any topic, it takes approx 5 to 6 seconds for the page to load, I want the search results to pop up quicker, does increasing the bandwidth of my site alleviate this issue? Or are there other solutions or suggestions you guys have?

Thanks for the help!:helpme

how big is ur sql db ?,
imho it depends on bandwidth+load+mysql .

good luck.,

btw its loading pretty quick here.

the home page loads quick, but when u click on a category it takes a bit of time dont you find?

the db has about 290k of url's. will bandwidth aid in speeding it?

Bandwidth won't help to increase the speed, it will only aid the amount you can serve, the only way to make your page faster is to optimize your table, maybe look at your indexes and decide what is needed to bring a query up fast (the fields your querying the most), or alternately move to a server with more processing power so it deals with your query quicker :D

Why don't you dump data of mysql into an search server? Solr can be a good beginning. It will take the load away from your mysql and get your search results faster.

Check out http://lucene.apache.org/solr/ for more info

Presnus, thanks for the link. I will look into that. I have used it with rails but never with php. Gotta figure that one out! have u ever tried it with php?

Yes :) it rocks

Presnus, amazing! is it easy to use with PHP as well? :-)

Yes very easy !

Try Google custom search. Nobody does search better than Google.
Try out th esearch box on one of our sites here:
http://ktog.org/cgi-bin/yabb2/YaBB.pl

Clicking the "search button" will break up the old script based search, while the search box on the front page is google custom search.

so i just found out my host doesnt support solr. Do you have a host you can recommend?
ugh! obstacles galore! :-P heheeh

Just rent a VPS and set up everything yourself :-)

Presnus, any recommendation for a good vps? I'm looking into it :-)

Contact me on ICQ 648332402

290k urls this is big.

how big is ur mysql db ? in mb ?

sorry 290k of thumbs, not urls. sorry!
Presnus I added u to icq. lemme know when ur on.

increasing bandwidth won't lead you to better speed. still you can try if you want to.

If you are loading a lot of thumbnails onto your page then you would need to make sure that they are optimised and the files are made as small as you can (filesize wise, not image wise) without sacrificing on quality, this is something I am currently looking into implementing on my site, I am just weighing up my options as to what would be the best approach for my site.

Once you know the search works (try it in development or on a different file) with just text links (you know how quick your db search is then), then look at how you can reduce the image sizes down, maybe have your page load progressively.

Rob

Absolutely. If you site is like most PHP scripts, the database is set up with no indexes whatsoever because the typical PHP "scripter" is actually pretty clueless about using MySQL correctly.