The last database i designed as a freelance database administrator is for dogs and puppy adoption site with all the fun stuff about dogs. I own two German sheperd dogs myself which are really cool to play with every evening.
The learning part about this project while working on puppies for sale website was the amount of text stored in the database. The huge amount of text data related to breed information facts and description. The existing developer who initially designed the database used varchar MAX for almost all the fields. Now the main part for me was to track all the data and see if i can fix some of this cowboy style database design.
Looks like the client is happy and all of the sudden site performance have increased, seperation of data and making table size small can really help which many front end developers does not understand specially when every query is select * from table. :)
Thursday, January 21, 2010
Subscribe to:
Posts (Atom)