| View previous topic :: View next topic |
| Author |
Message |
Localhost
I post too much
 Reputation: 0
Joined: 28 Apr 2007
Posts: 3402
|
 Posted: Mon Apr 06, 2009 3:51 pm Post subject: [PHP] Search Engine |
 |
|
Well, currently i run a site ( http://iRule.at/Music ) that has roughly 1 million songs in its database.
The problem i am running across is that my current search algorithm is slow and all around shit.
Maybe i am just expecting to much out of MySQL and PHP...
Is there anything i can do to make a more reliable search engine and faster?
_________________
|
|
| Back to top |
|
 |
Flyte
Peanuts!!!!
 Reputation: 6
Joined: 19 Apr 2006
Posts: 1887
Location: Canada
|
| Posted: Mon Apr 06, 2009 4:07 pm Post subject: Re: [PHP] Search Engine |
|
|
| localhost wrote: | Well, currently i run a site ( http://iRule.at/Music ) that has roughly 1 million songs in its database.
The problem i am running across is that my current search algorithm is slow and all around shit.
Maybe i am just expecting to much out of MySQL and PHP...
Is there anything i can do to make a more reliable search engine and faster? |
What are you currently using for a searching/sorting algorithm?
|
|
| Back to top |
|
|
Localhost
I post too much
Reputation: 0
Joined: 28 Apr 2007
Posts: 3402
|
| Posted: Mon Apr 06, 2009 6:33 pm Post subject: |
|
|
Would you like the MySQL query? it is basic...
_________________
|
|
| Back to top |
|
|
Flyte
Peanuts!!!!
Reputation: 6
Joined: 19 Apr 2006
Posts: 1887
Location: Canada
|
| Posted: Mon Apr 06, 2009 8:02 pm Post subject: |
|
|
| localhost wrote: | | Would you like the MySQL query? it is basic... |
Oh, so you are delegating all the work to MySQL? Bad idea, the performance would be absolutely horrific. You should really look into some sorting/searching algorithms. Hash maps, binary trees, quick sort, merge sort, etc. You probably won't use half of it in the search engine, but it's handy to know when someone tells you a searching algorithm finds stuff in logarithmic time.
|
|
| Back to top |
|
|
&Vage
Grandmaster Cheater Supreme
![]() Reputation: 0
Joined: 25 Jul 2008
Posts: 1053
|
| Posted: Mon Apr 06, 2009 8:44 pm Post subject: |
|
|
| Categorize the songs into genres? If it's not time consuming =D
|
|
| Back to top |
|
|
Localhost
I post too much
Reputation: 0
Joined: 28 Apr 2007
Posts: 3402
|
| Posted: Mon Apr 06, 2009 10:19 pm Post subject: |
|
|
| : wrote: | | Categorize the songs into genres? If it's not time consuming =D |
but it is pointless when people are just searching one word/string of words... and not genre + string of words.
Also, Flyte i will look into that. Mind pointing me into the right direction?
_________________
|
|
| Back to top |
|
|
NINTENDO
Grandmaster Cheater Supreme
![]() Reputation: 0
Joined: 02 Nov 2007
Posts: 1371
|
| Posted: Tue Apr 07, 2009 4:49 am Post subject: |
|
|
Can I write a search engine for you? (a)
_________________
Intel over amd yes. |
|
| Back to top |
|
|
Localhost
I post too much
Reputation: 0
Joined: 28 Apr 2007
Posts: 3402
|
| Posted: Tue Apr 07, 2009 10:47 am Post subject: |
|
|
I have decided i will most likely use either Lucene or Sphinx.
_________________
|
|
| Back to top |
|
|
Flyte
Peanuts!!!!
Reputation: 6
Joined: 19 Apr 2006
Posts: 1887
Location: Canada
|
| Posted: Tue Apr 07, 2009 10:51 am Post subject: |
|
|
| localhost wrote: | | I have decided i will most likely use either Lucene or Sphinx. |
| Website wrote: | | Apache Lucene is a high-performance, full-featured text search engine library written entirely in Java. |
|
|
| Back to top |
|
|
Localhost
I post too much
Reputation: 0
Joined: 28 Apr 2007
Posts: 3402
|
| Posted: Tue Apr 07, 2009 6:09 pm Post subject: |
|
|
| Flyte wrote: | | localhost wrote: | | I have decided i will most likely use either Lucene or Sphinx. |
| Website wrote: | | Apache Lucene is a high-performance, full-featured text search engine library written entirely in Java. |
|
I'm confused, are you saying Lucene is the best decision?
_________________
|
|
| Back to top |
|
|
Flyte
Peanuts!!!!
Reputation: 6
Joined: 19 Apr 2006
Posts: 1887
Location: Canada
|
| Posted: Tue Apr 07, 2009 6:13 pm Post subject: |
|
|
| localhost wrote: | | Flyte wrote: | | localhost wrote: | | I have decided i will most likely use either Lucene or Sphinx. |
| Website wrote: | | Apache Lucene is a high-performance, full-featured text search engine library written entirely in Java. |
|
I'm confused, are you saying Lucene is the best decision? |
| Quote: | ox⋅y⋅mo⋅ron
[-mawr-uh, -mohr-uh] Rhetoric.
a figure of speech by which a locution produces an incongruous, seemingly self-contradictory effect, as in “cruel kindness” or “to make haste slowly.” |
|
|
| Back to top |
|
|
oib111
I post too much
 Reputation: 0
Joined: 02 Apr 2007
Posts: 2947
Location: you wanna know why?
|
| Posted: Wed Apr 08, 2009 1:15 pm Post subject: |
|
|
He's saying Java is not a high performance language, while the website says that the search engine is high-performance, except it's written in Java, which isnt high performace, so it's an oxymoron.
_________________
| 8D wrote: |
cigs dont make people high, which weed does, which causes them to do bad stuff. like killing |
|
|
| Back to top |
|
|
Localhost
I post too much
Reputation: 0
Joined: 28 Apr 2007
Posts: 3402
|
| Posted: Wed Apr 08, 2009 3:00 pm Post subject: |
|
|
| oib111 wrote: | | He's saying Java is not a high performance language, while the website says that the search engine is high-performance, except it's written in Java, which isnt high performace, so it's an oxymoron. |
I thought it was something like that. But ISOHUNT uses them and has 1,000,000+ entries, and their search queries take 240ms
_________________
|
|
| Back to top |
|
|
Flyte
Peanuts!!!!
Reputation: 6
Joined: 19 Apr 2006
Posts: 1887
Location: Canada
|
| Posted: Wed Apr 08, 2009 3:06 pm Post subject: |
|
|
| localhost wrote: | | I thought it was something like that. But ISOHUNT uses them and has 1,000,000+ entries, and their search queries take 240ms |
I'm not saying don't use it; I was just commenting on how I found the statement funny. Then again, having met (and then subsequently made fun of) the lead sysadmin for IsoHunt, I'm not surprised they decided to use a Java library for something like that.
|
|
| Back to top |
|
|
chiryphp
How do I cheat?
![]() Reputation: 0
Joined: 28 Jan 2011
Posts: 1
|
| Posted: Fri Jan 28, 2011 8:07 pm Post subject: Free PHP Search Engine |
|
|
Recommend a site-PHPKode
where list some free php search engine projects.
Hopefully can help you!
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
