- Don’t query columns you don’t need, avoid using SELECT * FROM
- Use caching to reduce database load
- Normalize tables to ensure data consistency
- Use persistent connections
- Proper use of indexes improve performance
- Do not perform calculations on an index (eg: if you have an index for a column called salary, do not perform calculation such as salary * 2 > 10000)
- “LOAD DATA INFILE” is the fastest way to insert data into MySQL database (20 times faster than normal inserts)
- Use INSERT LOW PRIORITY or INSERT DELAYED if you want to delay inserts from happening until the table is free
- Use TRUNCATE TABLE rather than DELETE FROM if you are deleting an entire table (DELETE FROM delete row by row, whereas TRUNCATE TABLE deletes all at once)
- Always use EXPLAIN to examine if your select query is inefficient
- Use OPTIMIZE TABLE to reclaim unused space (Note: Table will be locked during optimisation, so only do it during low traffic time)
- Better to have 10 quick queries than 1 slow one
- MySQL can search on prefix of indexes (ie: If you have index INDEX (a,b), you don’t need an index on (a))
- Don’t use HAVING when you can use WHERE
- Use numeric values (rather than alphabetical values) when performing a join
Thanks
I like the valuable information you provide in your articles. I’ll bookmark your weblog and check again here regularly. I’m quite certain I’ll learn plenty of new stuff right here! Good luck for the next!
ReplyDeletesnow removal
I hate blogs with ads and publicity thing, a good blog is to inspire people and happy, make life more rich and wonderful, let more open perspective.
ReplyDeleteUniversity of Phoenix Online
This post shows the information which is close to standard. Hope next You will again post a nice Article/Information.
ReplyDeletedallas veneers
I wholeheartedly agree with your review.
ReplyDeleteaion accounts
I agree with your conclusions and will eagerly look forward to your incoming updates. Just saying thanks will not just be adequate, for the wonderful clarity in your writing.It is imperative that we read blog post very carefully
ReplyDeletemoving company in sacramento
I really appreciate this post. I’ve been looking all over for this! Thank goodness I found it on Bing. You’ve made my day! Thanks again! “One never goes so far as when one doesn’t know where one is going.
ReplyDeleteUniversity of Phoenix Online
I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business.
ReplyDeletecopper signs
I really appreciate this post. I’ve been looking all over for this! Thank goodness I found it on Bing. You’ve made my day! Thanks again! “One never goes so far as when one doesn’t know where one is going.
ReplyDeleteUniversity of Phoenix Online
Your article is simply fabulous. It’s got a lot of interesting information that is well-written, engaging and intelligent. Your ideas are very smart and fresh. Thank you for creating such unique content for your readers.
ReplyDeleteonline classes
This is definitely a blog that people need to get behind. The problem is, no one wants to do a great deal of reading and not have something else to stimulate the mind.
ReplyDeleteWOW gold
For your work you need a themes to make it a file for you to visit this site wordpress protfolio themes
ReplyDelete