Since two decades author and leadership consultant Frank Kanu helps top managers and executives to improve success ratios and productivity.
 About Frank Kanu  |  Testimonials  |  Order Books  |  Free Articles  |  Press  |  Excellence in Leadership  |  Genius One

Genius One Inc., Smart Solutions for Growth

Frank Uncovers Excellence in Leadership

Posts

How many test data do we really need?

© Copyright Frank D. Kanu 2000-2008

In the mid 90’s I was working on a project which had a designated data tester. In his opinion having a few hundred records in the database was enough. A few thousand he considered the upper limit. My request of having a few million records in the test database was seen as “crazy”.

Once I got my way the largest tables had around 1 million records each and the whole database roughly three million records. The developers and testers considered going postal on me - after all these tests took longer and some of the software had to be rewritten - because the user interface was crawling, at the best. Everyone told me how stupid it was to fill a database with that many records.

Half a year into production, one database had more than 60,000 personal records. The largest table had more than five million records.

At the end of the 90’s I worked on another project. A web based user interface. A live system used from more then 30 different customers. A lot of real test data available. The biggest database had a few million records altogether. Many fields were blobs, normalization wasn’t really done. The whole programming team - including management - didn’t see the need for any testing on databases with more then a handful records.

When it works with one record, it will work with a few million records.

Yeah, right!

One of their websites regularly timed out - the SQL just took too much time. So what did the developer do? Takes his test database. Two records in the one table, twenty, thirty in another one. Plus a handful more in the other tables involved in a badly written join. SQL takes a few seconds to run. Then he comes to me: “I don’t understand. My computer is slower then the server, yet the result page shows up in seconds!”
Well, duh! The customer database had a few hundred thousand records in the tables which got joined.

Yet until today that development team still insists that testing with the smallest database possible is all what it takes.

How many test data do you generate?

Tags:
1 million  blobs  customer database  databases  developers  development team  duh  handful  hundred thousand  join sql  million records  normalization  personal records  programming team  sql  test data  test database  testing  user interface  web based  yeah right
 Technorati (All Links are external): 1 million  blobs  customer database  databases  developers  development team  duh  handful  hundred thousand  join sql  million records  normalization  personal records  programming team  sql  test data  test database  testing  user interface  web based  yeah right  it
 
Digg  del.icio.us  StumbleUpon  Technorati  Reddit This blog-entry is protected by a digital fingerprint:785273ed81985582c8a1be62f78c9459
 
  • Frank Kanu on Wednesday, September 8th, 2004 @ 06:45
  • Filed under IT


You can follow responses to this entry through the RSS 2.0 feed.

Readers, who enjoyed reading this posting, also read:
  • Top 25 Explanations by Programmers when their programs don't work
  • business data quality
  • Myer-Briggs Test For Programmers
  • How smart are you?
  • Music or data?

Because I value your thoughtful opinions, I encourage you to add them.

Please leave your Response right here:




XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>



Please do not be offended if I edit your response for clarity or to keep out questionable matters, however, and I may even delete off-topic responses.

Archives and Links




« IT Labor Boomerangs Back Home     Phishing »


  • Tags
    • blog
      confucius
      decisions
      e book
      education
      failure
      few days
      followers
      job
      kanu
      leader
      leaders
      leadership skills
      love
      mail
      manager
      managers
      mistakes
      money
      president bush
      programmers
      questions
      start leading
      stop telling
      success

    • Tags sorted alphabetically
    • Tags sorted numerically
  • Categories
    • Business
      • Case Studies
      • Negotiations
    • Cooking
    • Definitions
    • Ethics
    • Events
    • Frank Kanu
    • General
      • Daily Question
      • Quote of the Day
      • Weekly Poll
    • IT
      • Code review
    • Leadership
    • Management
      • Teams
    • Motivation
    • Politics
    • Something funny
    • Stop Telling… Start Leading!
  • Random Posts
    • - How calm are your nights?
    • - Software Evaluations
    • - Samsung shows ‘world’s first’ hard drive phone

    • blogmap
    • More about Frank
  • Links
    • Frank Kanu's Books
    • - Andy Coote
    • - Andy Wibbels
    • - Billy McDermott*s Blog
    • - Blogcritics
    • - dandrea projetos
    • - David Intersimone “David I”
    • - Derek Jones
    • - Develop Your Vision
    • - enhance your leadership skills
    • - Forbes.com
    • - Frank Kanu
    • - Frank Kanu’s article archive
    • - Genius One
    • - Handelsblatt
    • - Karel’s Legal Blog
    • - Managing Leadership
    • - New York Nitty-Gritty
    • - News for nerds, stuff that matters
    • - Philip Greenspun’s Weblog
    • - Practical Developmental Ideas
    • - Practical Solutions to Business Puzzles
    • - Recipes
    • - Rick Cooper, The PDA Pro
    • - Roberta Pili
    • - Sacred Cow Dung
    • - Savvy Intrapreneur
    • - Scrapbooker for hire
    • - Scrapbooking 4 others
    • - seth godin’s blog
    • - stop telling… start leading!
    • - The Art of Managing People by Asking Questions
    • - The Washington Post
    • - TomPeters!
  • RSS Feed
    • Syndicate using RSS
    • The latest comments to all posts in RSS
  • Archives/Calendar
    • yearly archives
    • monthly archives
    • weekly archives
    • daily archives
    December 2008
    M T W T F S S
    « Nov    
    1234567
    891011121314
    15161718192021
    22232425262728
    293031  
  • Blog Of The Day Awards Winner

If not otherwise stated - all postings © Frank D. Kanu. All rights reserved.

This blog is designed to provide accurate and authoritative information in regard to the subject matter covered.
If legal advice or other expert assistance is required, the services of a competent professional should be sought.



Genius One Inc. · USA
Fax: (509) 463-0129 · E-mail:
info@GeniusOne.com

 


Privacy Statement   Sitemap

 
Copyright © 2000-2008 Genius One Inc.
All rights reserved.
Reproduction or use in whole or part in any form or medium without written permission of Genius One Inc. is prohibited.
If parts or any part of these WebPages is judicially determined to be invalid, that invalidity will not affect the remaining part of these Pages.