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
Hi,
You can optimize your table index, for more information please go through the link http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html
Good Luck 
Regards
Amit