Attention: We are retiring the ASP.NET Community Blogs. Learn more >

.NET Pet Shop

John Lam found the same problems we did with the .NET Petshop database schema.  Our article was written looking at the .NET PetShop 1.5 version. In the 2.0 version the database schema is still worse.

 

3 Comments

  • the question is... does dropping constraints/DRI/etc actually improve performance??? Not that I'm even close to advocating this, but if you drop all of your constraints/DRI/etc and you gain a 20% increase in the performance of your database server, and your application level code more or less already is performing the same validations, then is this a worthwhile performance tuning action?





    I've never tried this, but has someone out there done this and proven the relatively large performance increase? Or is the performance impact of constraints/DRI/etc so minimal (meaning 1-2%) that you'd be stupid to not use them?

  • I will test it. Anyway it does not look as a valid tuning strategy...

  • WHile i must say that I consider what you do with the database schema presented pretty idiotic (and just to cover up for deklarit's restrictions of not being a real O/R mapper), the comments you did on the quality of the original schema are interesting. I mean, this stuff is SO bad, it is unbelievable.

Comments have been disabled for this content.