Submit Your Article Forum Rules
Results 1 to 4 of 4

Thread: Search Engine for my site

  1. #1

    Search Engine for my site

    Search Engine for my site Hello,
    I have a website ( 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: try some of them. and give me some suggestions.

    Many thanks
    Hidden Content - lyrics for all and for free
    Hidden Content (Hidden Content )

  2. #2

    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

    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.
    Hidden Content - lyrics for all and for free
    Hidden Content (Hidden Content )

  4. #4

    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