Are there any MYSQL resources to learn about indexes and optimizing queries?

Author Name Status Posted Time Lehla M’meindram 10/29/2008 3:35:04 AM Author is Offline Hi guys, I have been working on learning php / MYSQL but I want to find some good tutorial or resource about MYsql (and sql language used in MYSQL). I would like to learn a good deal about indexes and optimizing queries befoe I take the plunge into designing a php/MYSQL website. Any sugestions? Thanks Lehla

Subject Author Status Date Re: Are there any MYSQL resources to learn about i ndexes and optimizing queries? Clifford Haff 10/30/2008 2:44:19 AM Lehla, This might not be a lot of help, but I learned eve rything I know from the manuals at php.net and mys ql.com Post Comments Re: I agree with u Oniel Hanley 10/30/2008 2:45:14 AM I agree with Clifford. The manuals on these two sites are quite possibly the best resources for these products online. I d ownloaded the .chm help files and use them daily. Post Comments Re: Are there any MYSQL resources to learn about i ndexes and optimizing queries? Amrutha Vinay 10/30/2008 2:45:54 AM What helped me gain an understanding of php and mysql was downloading and installing phpnuke (or myphpnuke) from the beginning (not using cpanel) and getting in and tweaking and breaking. Helped immensely. Post Comments Re: Are there any MYSQL resources to learn about i ndexes and optimizing queries? Nirmal Pandey 10/30/2008 2:48:51 AM Look up relational database design in general. Tha t is what teaches good table and record design as well as how to use indexes and what type indexes perform best and which can be pitfalls. Post Comments Re: Are there any MYSQL resources to learn about i ndexes and optimizing queries? Boney Fairholm 10/30/2008 2:49:06 AM Find a class in database design at a local community college or university. It helps tremendously and you get a feel for the database concepts in general. Post Comments

Related Forums Optimizing Images Get a Website Template for Free!!! Get a Website Template for Free!!! Reply to Hesus!!! Do You Sell Your Templates on Ebay?