fast search

[hno]

HI every one

 

I have about 1 million queries in my database .If i want to search for a query , What is the best way ? fast and with low usage of web server's cpu and memory  ?

 

thanks

[jonsjava]

Step 1: optimize the tables, and make sure that you index important columns (it will search through it faster, but don't index everything).

Step 2: if you are running MySQL >= 5.1, use stored procedures

Step 3: Select ONLY the data you need:

  Lets say you have a table that has `id`,`f_name`,`l_name`,`address1`,`address2`,`city`,`state`,`zip`,`zip_4`,`phone1`,`phone2`,`phone3`,`website`,`sig`

  If you only need to get the `id` and the `website`, don't call everything, do this:

SELECT `id`,`website` FROM `table_name` WHERE `f_name`='john' AND `l_name`='doe' LIMIT 1;