Great article. You have really illustrated the key things that are needed for indexing the web. In fact, these are the most important but oft-forgotten tweaks!
“Think of it this way—it’s like looking up the word “poultry” in the back of the cookbook instead of flipping through each page and putting a marker on all the chicken dishes.”
That summarizes the entire article in a nutshell. Good advice on how to keep databases running smoothly and efficiently, thanks.
It is not only me most of the webmasters and SEO experts would be thinking that indexing is Google’s job. But now I got what to do to make the search engines index the pages of the websites.
Database optimization is an often-overlooked aspect of web development. Many of the projects I’ve worked on pay absolutely no attention to it – to the extent that the only index on a given table is a primary key. Optimizations can have vast impacts on server performance; I recently built an ajax-based real time chat app that saw performance gains of about 60 times with some indexing and SELECT query optimizations. The “SELECT … USING” syntax is a godsend for hinting the database to use an indexed column in a multi-column select condition.
22 Reader Comments
Back to the Articlemagicman24
that’s a really interesting article. I remember the days where it took about 30 minutes to index a page :)
Mike Hersh
imblogging.com
elearningflash
Sounds like building a good website is like building a good building
If the foundations are stable, it will last for a good while.
Maneet Puri
Great article. You have really illustrated the key things that are needed for indexing the web. In fact, these are the most important but oft-forgotten tweaks!
Thanks for sharing!
unbrandedc
“Think of it this way—it’s like looking up the word “poultry” in the back of the cookbook instead of flipping through each page and putting a marker on all the chicken dishes.”
That summarizes the entire article in a nutshell. Good advice on how to keep databases running smoothly and efficiently, thanks.
stuartmarsh
It was interesting that you mentioned frameworks. I use Django, I just checked the MySQL tables it creates, and it seems to index the foreign keys.
But it’s a lesson learned for me, as I’ve never really looked at database optimisation before. Time to start I feel!
Thanks
shapiawebdesigns
It is not only me most of the webmasters and SEO experts would be thinking that indexing is Google’s job. But now I got what to do to make the search engines index the pages of the websites.
JohnShuffle
Reading the acticle I hate to say that Google dictates our behavior forcing us to pay 24/7 attention if you do website promotion
Justen Robertson
Database optimization is an often-overlooked aspect of web development. Many of the projects I’ve worked on pay absolutely no attention to it – to the extent that the only index on a given table is a primary key. Optimizations can have vast impacts on server performance; I recently built an ajax-based real time chat app that saw performance gains of about 60 times with some indexing and SELECT query optimizations. The “SELECT … USING” syntax is a godsend for hinting the database to use an indexed column in a multi-column select condition.
Montmorency
Here is the translation of the article: http://interpretor.ru/sql_indexing
Thanks for the great article!
flash bannere
Interesting article! And this commentfield is really well designed :)
webdesign center
Great reading, very good article. Thank you
1smykke.dk
Helped me realize some very good points.