1 Very interesting

This is a fantastic article to see on ALA. In one of my past lifes I carried out a lot of performance testing and tuning web applications. If developers can make sure these simple things are done when the application is coded it will make everyone lives easier in the long term.

The difference to the user experiance will also be dramatic, the first time I ran a performanced tuned application I could not believe the difference it made.

Phil

posted at 10:01 am on June 9, 2009 by welovenicethings

2 Nicely written article

I really enjoyed this article and could impliment a couple of the points listed – especially indexes on varchar type fields, which already shows some speed increases in one of my sites.

posted at 10:26 am on June 9, 2009 by AdriaanNel

3 Great

I really appreciate this article because it was a post more technical than usual. Most of the time, we discuss size reduction (removing exif on pictures, better compressions), number of files downloaded (css sprites, css group), cache and http issues so theses advices are welcome !

posted at 10:35 am on June 9, 2009 by Christophe BENOIT

4 Nice article

Webbies failing to think seriously about databases has to be one of the major problems of web application development. Unfortunately “toys” (and dangerous ones if incorrectly used) like MySQL and the associated literature don’t help. Articles like this can help to change this. Anyone starting out and looking for a free DBMS might one a look at PostgreSQL as it automatically creates indexes for any foreign keys that a table references, so you get performance + referential integrity. Add bound parameters to the client and you give the database chance to cache the query and you’re protected against SQL injection. Happy days!

posted at 12:17 pm on June 9, 2009 by Charlie Clark

5 Really?

So let me get this straight – having the same fields in the database yet declaring a few select ones as ‘index’ changes all of this? Really??

By the way, the site == great in expressionengine!

posted at 02:05 pm on June 9, 2009 by carolinecblaker

6 Foreign Key indices

I believe MySQL automatically creates an index when you create a foreign key constraint, which makes this advice even easier to follow, assuming you’re using a storage engine with foreign keys.

Another related topic that could help out the same audience is an introduction to normalization…

posted at 04:38 pm on June 9, 2009 by Michael Newton

8 Great article!

Thanks for a very informative article. The little things that make a huge difference in indexing the web… And they do make a difference.

posted at 08:17 pm on June 9, 2009 by forex

9

Thanks Lyle, great explanations and very informative!

posted at 09:29 pm on June 9, 2009 by Bjørn Enki

10 Excellent Article

Yes this id true i found a huge difference in indexing the web.
This article help you to indexing a web…thanx for giving this type of articles which help other…Thanx Again

posted at 03:41 am on June 10, 2009 by darsh39