hno Posted July 12, 2010 Share Posted July 12, 2010 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 Quote Link to comment Share on other sites More sharing options...
jonsjava Posted July 12, 2010 Share Posted July 12, 2010 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; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.