MySQL Forums
Forum List  »  Performance

Mysql Speed Optimization
Posted by: César Couto
Date: April 19, 2005 05:17AM

I'm having several server overload problems because of mysql queries and the increasing databases sizes, so i have a few questions.

How much different in speed is...
1 - SELECT * FROM ....
2 - SELECT id_foto, img1, img2 FROM...

Is the second choice much faster ?

I've read some optimization tips in mysql website using indexes and so but it does't seem it would work with my databases.

For example, if a have a photo gallery, is it usefull to create an index of the id_photo ? (id_photo is the primary key)

If someone have some mysql speed optimization tips or links and could share i would apreciate.

Sorry the bad english.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql Speed Optimization
5966
April 19, 2005 05:17AM
2424
April 24, 2005 04:03PM
2265
April 25, 2005 02:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.