posted on Thursday, May 25, 2006 5:33 PM by SimonSabin

Are you allowed to be sizeist in the database world

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Are you allowed to be sizeist in the database world
The new RSS feed is here

Well even if your not, one of my real bug bears is fat tables. These aren't large tables they are fat tables, wide ones with lots of columns or large data types.

The reason this gets is is people develop databases with 10s of rows in them. Then end up with millions of rows in them in a live environment and find this things just don't perform.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Are you allowed to be sizeist in the database world

Comments

# re: Are you allowed to be sizeist in the database world @ Friday, May 26, 2006 6:15 AM

I find it sad that data modelling does not appear to feature in many dba's or developers training. It takes time to model correctly, I guess most projects are so time strapped good design goes out of the window.
Poor testing is also a cuplrit - I rarely see much evidence of scale up and scale out testing - I often see the end results - as you rightly note - I have a number of stories concerning such.

colin leversuch-roberts