Faster search results - GoFuckYourself.com

xmonkeys · 06-22-2011, 11:42 AM

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!

cooldude7 · 06-22-2011, 11:58 AM

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

good luck.,

cooldude7 · 06-22-2011, 12:01 PM

btw its loading pretty quick here.

xmonkeys · 06-22-2011, 12:13 PM

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?

robber · 06-22-2011, 04:10 PM

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

Presnus · 06-22-2011, 10:24 PM

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

xmonkeys · 06-23-2011, 09:33 AM

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?

Presnus · 06-23-2011, 09:39 AM

Quote:

Originally Posted by xmonkeys

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

xmonkeys · 06-23-2011, 10:59 AM

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

Presnus · 06-23-2011, 11:03 AM

Quote:

Originally Posted by xmonkeys

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

Yes very easy !

raymor · 06-23-2011, 12:37 PM

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.

xmonkeys · 06-23-2011, 03:55 PM

Quote:

Originally Posted by Presnus

Yes very easy !

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

Presnus · 06-23-2011, 10:38 PM

Quote:

Originally Posted by xmonkeys

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 :-)

xmonkeys · 06-24-2011, 08:42 AM

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

Presnus · 06-24-2011, 09:11 AM

Contact me on ICQ 648332402

cooldude7 · 06-25-2011, 11:13 AM

Quote:

Originally Posted by xmonkeys

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?

290k urls this is big.

how big is ur mysql db ? in mb ?

xmonkeys · 06-25-2011, 03:25 PM

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

dc0ded · 07-19-2011, 05:05 PM

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

robber · 07-20-2011, 02:05 AM

Quote:

Originally Posted by xmonkeys

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

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

raymor · 07-20-2011, 10:14 AM

Quote:

Originally Posted by robber

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)

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.

06-22-2011, 11:42 AM	#1
xmonkeys Confirmed User Industry Role: Join Date: Feb 2011 Posts: 121	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!

06-22-2011, 11:58 AM	#2
cooldude7 Confirmed User Industry Role: Join Date: Nov 2009 Location: Heaven Posts: 4,306	how big is ur sql db ?, imho it depends on bandwidth+load+mysql . good luck., Last edited by cooldude7; 06-22-2011 at 12:00 PM..

06-23-2011, 12:37 PM	#11
raymor Confirmed User Join Date: Oct 2002 Posts: 3,745	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. __________________ For historical display only. This information is not current: support@bettercgi.com ICQ 7208627 Strongbox - The next generation in site security Throttlebox - The next generation in bandwidth control Clonebox - Backup and disaster recovery on steroids

07-19-2011, 05:05 PM	#18
dc0ded Confirmed User Industry Role: Join Date: May 2011 Location: Bedworth, United Kingdom Posts: 1,022	increasing bandwidth won't lead you to better speed. still you can try if you want to. __________________ Guaranteed Adult SEO Service- Just $275 per month

06-22-2011, 12:01 PM	#3
cooldude7 Confirmed User Industry Role: Join Date: Nov 2009 Location: Heaven Posts: 4,306	btw its loading pretty quick here.

06-22-2011, 12:13 PM	#4
xmonkeys Confirmed User Industry Role: Join Date: Feb 2011 Posts: 121	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?

06-22-2011, 04:10 PM	#5
robber Web Developer Industry Role: Join Date: Jan 2011 Location: UK Posts: 264	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

06-22-2011, 10:24 PM	#6
Presnus Confirmed User Industry Role: Join Date: May 2011 Posts: 1,087	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

06-23-2011, 09:33 AM	#7
xmonkeys Confirmed User Industry Role: Join Date: Feb 2011 Posts: 121	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?

06-23-2011, 10:59 AM	#9
xmonkeys Confirmed User Industry Role: Join Date: Feb 2011 Posts: 121	Presnus, amazing! is it easy to use with PHP as well? :-)

06-24-2011, 08:42 AM	#14
xmonkeys Confirmed User Industry Role: Join Date: Feb 2011 Posts: 121	Presnus, any recommendation for a good vps? I'm looking into it :-)

06-24-2011, 09:11 AM	#15
Presnus Confirmed User Industry Role: Join Date: May 2011 Posts: 1,087	Contact me on ICQ 648332402

06-25-2011, 03:25 PM	#17
xmonkeys Confirmed User Industry Role: Join Date: Feb 2011 Posts: 121	sorry 290k of thumbs, not urls. sorry! Presnus I added u to icq. lemme know when ur on.