SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Addict
    Join Date
    Sep 2008
    Posts
    228
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    search system using php mysql

    please i want to make a search system for my website

    i have 2 ideas
    1- the first one is to search in my phpmyadmin tables and columns but it takes a very long time to get result

    2- my second idea is to make an XML file using cron job and search in it when the user press search..

    can anyone tell me which idea is better?? and if anyone has another idea please advice

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,022
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    i would definitely use option 1 because it scales

    if your queries are currently taking "a very long time" then perhaps you need to optimize your table indexes
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Sep 2008
    Posts
    228
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    i would definitely use option 1 because it scales

    if your queries are currently taking "a very long time" then perhaps you need to optimize your table indexes
    ]


    thanks for your reply but i dont know how to optimize my table indexes??? please advise

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,022
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    google optimize mysql queries -- there are tons of articles out there
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    Non-Member
    Join Date
    Nov 2012
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,
    You can optimize your table index, for more information please go through the link http://dev.mysql.com/doc/refman/5.1/...ize-table.html
    Good Luck :-)
    Regards
    Amit


Bookmarks

Posting Permissions

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