Read posts about scalability in other sites

count(*) is the devil, stay away from it!

Posted by Emilio Davis on 06/16/2010 at 12:42 PM

MyISAM, an aged MySQL engine with no transactional support and awful scalabililty spoiled many developers with an ultra fast count(*) implementation. But is ultra fast only when there is no conditions in the where part of the sentence.

At least in InnoDB (the common replacement for MySQL, at least until Maria gets more traction) every count(*) has to make a temporary table with all the matching lines and the count the lenght of the table.

There are two ways to deal with count(*).

1.- Don't use count(*) rather count(primaryKey).

     In InnoDB the primary key is always part of any index

(Read more)
Tags:
Share this | Comment |
3
0

Webprendedor 2009 - Web Apps Scalability workshop (slides)

Posted by Emilio Davis on 11/21/2009 at 09:22 AM

This are the slides of the talk I gave in #wp09 about scalability. They are in spanish but I will translate them to english in the near future.

 

Webprendedor 2009 Escalabilidad
View more presentations from edavism.

Tags:
Share this | Comment |
0
0

Webprendedor 2009 - Web Apps Scalability workshop

Posted by Emilio Davis on 11/15/2009 at 12:38 AM

This Nov 20th I will give a talk on the challenge of scalating a web application, main topics will be:

  • Plan to grow: While building your app, ALWAYS consider scalability.
  • Know your technology stack: From the file system to the edge cache.
  • Keep it simple: DB sharding, just say no.
  • Be ready to change: Have you considered NoSQL already?
  • Don't be lazy: Great for prototyping not necesarily means good for production.
  • Performance tunning: chasing the next bottleneck.

Check http://www.webprendedor.com for the rest of the workshops and related info.

Tags:
Share this | Comment |
3
0