hello friends....
I am PHP programmer using mysql as my database...
Now it is the time to make fast all my queries ,which im using in my programming...
I heard about indexing...
Tel me what is indexing,how to put indexing to my table...
mainly what are the advantages and disadvantages...or any more about indexing...
Thanks in advance..
Shanti.
Jump to Posthttp://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html
This may be a good start.
Jump to PostYes, sometimes. Indexing speeds things up a lot. Some queries can be rewritten to avoid joins. But databases keep getting better in speeding it up themselves.
If you use complex indexes (multiple fields) it is best to use those fields in your query in the same order. That way …
thanks pritaeas...
i heard that joins take more load time...
is it right???
then how to justify our queries...
Yes, sometimes. Indexing speeds things up a lot. Some queries can be rewritten to avoid joins. But databases keep getting better in speeding it up themselves.
If you use complex indexes (multiple fields) it is best to use those fields in your query in the same order. That way the engine has less trouble getting things together fast.
Personally, I got a lot of info from this book:
http://www.amazon.com/SQL-Performance-Tuning-Peter-Gulutzan/dp/0201791692
thanks again pritaeas...
Is there any information about indexing,joins to speed up my query loading???
you'll have to google for it. normally, it is rather specific to a particular kind of query. there is a lot of information out there, but it takes some time to find.
E.g.
http://www.databasejournal.com/features/mysql/article.php/1382791
http://hackmysql.com/documents
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.
