Search Engine for my site

[vsd32]

Search Engine for my site Hello,
I have a website (http://www.lyricsrec.com/) and i want to develop a search facility for my site.
I'm using Mysql and i have all lyrics (>150.000) in a database. I have some suggestions how to do it but i do not like the time response.
I have the lyrics also on static pages and i want dome suggestions how to do it using my static pages.

Some internal pages you can check here:
http://www.lyricsrec.com/index2.php try some of them. and give me some suggestions.

Many thanks

[speed]

As all your data is in MySQL I'd use MySQL full text search.

If that isn't up your street then:

• Use Google search, but this doesn't seem to work for your site because you don't seem to have any pages indexed.
• Use a search engine such as http://www.sphider.eu/
• Roll your own engine using the search library from Zend, http://framework.zend.com/manual/en/...ch.lucene.html. This has the advantage that it only indexes what you feed it.

[vsd32]

I would like to develop a search engine witch will read the static pages.
If i'm using the other one (queyes from db) it's to slow (more that 10 sec for reply) so that one is working for small dbases.

Or i'm opened to other suggestions how to use my huge mysql db with a better response time.

[speed]

If mysql full text queries are taking that long it sounds like you've got something incorrectly configured. Did you create an full text index? Is your match using the identical columns to the full text index?

You could try sphider quite easily and see how that goes.

If not then you'd need to do some experimenting with Zend Frame work to see how the performance of search is. Indexing is just travelling though the pages extracting useful information from fluff and sending it to the engine, if it's all in MySQL then the extraction is already done for you.

You might get more speed by using C/C++, Java etc, Apache Lucene - Overview is a search library for Java.