Lynn Pettis (3/1/2013)
I'll have to disagree with you and side with Jeff. I have learned much from him and scalability and reuse actually come hand in hand. If you take the time now to build scalable code (read routines) that can be reused then spend the time. Just because it is good enough for a particular use does not mean it will be for another. Many times people will take what you have written and use it where it really shouldn't because it was just good enough for that one instance.
If you have a limited amount of time, spend your time on the code which goes into (onto) the production system.
I use a huge amount of queries studying the database and effects of code on the database (performance, frequency studies, fragmentation). I try to write these queries fast (and unoptimised). Yes sometimes I wait for two minutes and sometimes I improve those queries.
And Yes this forum is of great value, for both production systems (were efficiency counts) and for producing code which works fast enough for non production systems. Often good code and readability goes hand in hand. But sometimes readability is offered to increase efficiency. But if I have to make a choice readability is of greater importance except if performance really matters. But this forum has attention for that as well. For me this forum is of more importance to learn and produce the code myself than, allthough I often use code of this forum as wel, which is also of great value.
Thanks all for taking part in this thread,
ben