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

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

google optimize mysql queries – there are tons of articles out there

You can optimize your table index, for more information please go through the link
Good Luck :slight_smile: