Faster search results

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • xmonkeys
    Confirmed User
    • Feb 2011
    • 121
    #1

    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!
    Tags: None
    • cooldude7
      Confirmed User
      • Nov 2009
      • 4306
      #2
      how big is ur sql db ?,
      imho it depends on bandwidth+load+mysql .

      good luck.,
      Last edited by cooldude7; 06-22-2011, 11:00 AM.

        Comment

        • cooldude7
          Confirmed User
          • Nov 2009
          • 4306
          #3
          btw its loading pretty quick here.

            Comment

            • xmonkeys
              Confirmed User
              • Feb 2011
              • 121
              #4
              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?

                Comment

                • robber
                  Web Developer
                  • Jan 2011
                  • 264
                  #5
                  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

                    Comment

                    • Presnus
                      Confirmed User
                      • May 2011
                      • 1087
                      #6
                      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

                        Comment

                        • xmonkeys
                          Confirmed User
                          • Feb 2011
                          • 121
                          #7
                          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?

                            Comment

                            • Presnus
                              Confirmed User
                              • May 2011
                              • 1087
                              #8
                              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

                                Comment

                                • xmonkeys
                                  Confirmed User
                                  • Feb 2011
                                  • 121
                                  #9
                                  Presnus, amazing! is it easy to use with PHP as well? :-)

                                    Comment

                                    • Presnus
                                      Confirmed User
                                      • May 2011
                                      • 1087
                                      #10
                                      Originally posted by xmonkeys
                                      Presnus, amazing! is it easy to use with PHP as well? :-)
                                      Yes very easy !

                                        Comment

                                        • raymor
                                          Confirmed User
                                          • Oct 2002
                                          • 3745
                                          #11
                                          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

                                            Comment

                                            • xmonkeys
                                              Confirmed User
                                              • Feb 2011
                                              • 121
                                              #12
                                              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

                                                Comment

                                                • Presnus
                                                  Confirmed User
                                                  • May 2011
                                                  • 1087
                                                  #13
                                                  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 :-)

                                                    Comment

                                                    • xmonkeys
                                                      Confirmed User
                                                      • Feb 2011
                                                      • 121
                                                      #14
                                                      Presnus, any recommendation for a good vps? I'm looking into it :-)

                                                        Comment

                                                        • Presnus
                                                          Confirmed User
                                                          • May 2011
                                                          • 1087
                                                          #15
                                                          Contact me on ICQ 648332402

                                                            Comment

                                                            • cooldude7
                                                              Confirmed User
                                                              • Nov 2009
                                                              • 4306
                                                              #16
                                                              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 ?

                                                                Comment

                                                                • xmonkeys
                                                                  Confirmed User
                                                                  • Feb 2011
                                                                  • 121
                                                                  #17
                                                                  sorry 290k of thumbs, not urls. sorry!
                                                                  Presnus I added u to icq. lemme know when ur on.

                                                                    Comment

                                                                    • dc0ded
                                                                      Confirmed User
                                                                      • May 2011
                                                                      • 1022
                                                                      #18
                                                                      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

                                                                        Comment

                                                                        • robber
                                                                          Web Developer
                                                                          • Jan 2011
                                                                          • 264
                                                                          #19
                                                                          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

                                                                            Comment

                                                                            • raymor
                                                                              Confirmed User
                                                                              • Oct 2002
                                                                              • 3745
                                                                              #20
                                                                              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.
                                                                              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

                                                                                Comment

                                                                                Previous template Next
                                                                                Working...