Re: Help Needed on Query Optimization
- Hai sudhir,
One of the most widely used technique to solve this problem; by
indexing the search field. I mean database indexing.
The major problem is that. for indexing. it will take lot of time.
indexes are designed for faster searches. indexing unwanted fields may
degrade the performance of the system.
--- In firstname.lastname@example.org, sudhir saini <sudhir_xprt@...> wrote:
> I had a search query and i ahd a table in which i had
> I have to implement to search on that.i am using PHP5 and mysql
4,when i m runnig this query server will go down(can't find server).
> Please suggest how i can solve this problem or how i can optimize my
> Thanks & Regards,
> Sudhir Kumar Saini.