Web Design and Development Forums

Improving MySQL Performance

This is a discussion on "Improving MySQL Performance" within the MySQL section. This forum, and the thread "Improving MySQL Performance are both part of the Databases category.


Go Back   Webforumz.com > Databases > MySQL
Reload this Page Improving MySQL Performance
Register All AlbumsBlogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Welcome to Webforumz.com.
Register Now Register now!

Reply
 
LinkBack Thread Tools Rate Thread
Old Feb 11th, 2008, 15:42   #1 (permalink)
Junior Member
 
Join Date: Jul 2006
Location: Nottingham, UK
Age: 37
Posts: 24
Send a message via MSN to dartiss Send a message via Skype™ to dartiss
Improving MySQL Performance
Hi,

Are there any coding techniques that are recommended for improving the reading time of small MySQL tables?

My site reads a few for page generation and, although the site is hardly slow, it's one area that could be improved.

Either SQL coding or the way my tables are defined.

If they are small, will having indexes be slowing them down? If so, should I have a unique field in preference to an index, for instance?

All help appreciated.
David.
dartiss is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

« Complicated database querys | AbsolutePage in MySQL »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Advice on improving google rankings trophy3681 Search Engine Optimization (SEO) 7 Feb 19th, 2008 13:09
Pacific Performance Engineering stupid dog Free Web Site Critique 7 Aug 14th, 2007 20:13
sujestions on improving rank for 1 keyword rocket468 Website Planning Discussion 1 Aug 6th, 2007 23:38
Retreive Performance Monitor Counter objects in ASP kebi Introduce Yourself 1 Oct 10th, 2005 12:00
FSO (File System Object) Performance spinal007 ASP Forum 17 Mar 16th, 2005 18:03



Latest Updates

All Points SEO Security Advisory - CHECK YOUR SITE NOW!

Creative Coding :: February 2008
Webforumz is sponsored by: WESH UK Web Hosting
All times are GMT. The time now is 06:08.

Sleep Study Scoring :: Free Bet :: Website Templates :: Online Betting :: Bookmakers :: Funny Quotes :: Internet Recruitment Software :: Microsoft CRM Experts :: Online Casino :: Decorated Christmas Trees :: Midwife Forums :: Football Betting :: Ecommerce Software :: Web Hosting :: Football Stats :: Dry Cleaning Collection :: xtreme wales - extreme clothing :: Apuestas :: Sharepoint Consultants :: Website Optimisation :: Office Clearance London :: Sharepoint Experts :: Sports Betting :: Casino :: Website Templates :: Web Design Development India :: Online Gambling

Powered by: vBulletin Version 3.7, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
© 2003-2008 Webforumz.com : All Rights Reserved
Search Engine Friendly URLs by vBSEO 3.2.0 RC6


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59