Submit Your Article Forum Rules

Results 1 to 4 of 4

Thread: Search Engine for my site

  1. #1
    Junior Member
    Join Date
    Jun 2007
    Posts
    15

    Search Engine for my site

    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

  2. #2
    WebProWorld MVP
    Join Date
    Aug 2003
    Posts
    1,020

    Re: Search Engine for my site

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

    If that isn't up your street then:

  3. #3
    Junior Member
    Join Date
    Jun 2007
    Posts
    15

    Re: Search Engine for my site

    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.

  4. #4
    WebProWorld MVP
    Join Date
    Aug 2003
    Posts
    1,020

    Re: Search Engine for my site

    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.

Similar Threads

  1. Upgrade search on your site with Google Custom Search Engine
    By danlefree in forum Web Programming Discussion Forum
    Replies: 33
    Last Post: 01-18-2010, 01:39 PM
  2. Site Search Engine???
    By mkinzie1 in forum Database Discussion Forum
    Replies: 9
    Last Post: 08-18-2007, 03:04 PM
  3. Is my site in this search engine - how do I know?
    By Pegger in forum Marketing Strategies Discussion Forum
    Replies: 1
    Last Post: 07-10-2004, 02:33 PM
  4. Site search engine?
    By ergobob in forum Graphics & Design Discussion Forum
    Replies: 2
    Last Post: 07-06-2004, 01:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •