View Single Post
Old 10-06-2011, 03:44 PM   #2
Newly Registered User
Join Date: Nov 2010
Posts: 158
Thanks: 1
Thanked 19 Times in 19 Posts
bparkinson is on a distinguished road
Re: Database efficiency with generating tables.

Avoid the issue entirly. Don't persist derived/calculated values like the cost of raw materials. Instead, calculate them on the fly in a query as needed.

The last thing you want to do is multiply the cost of a part by the quantity estimated for the job and store that.

This design can never scale, and performance could well be terrible.
bparkinson is offline   Reply With Quote