I would agree that it's web development as a whole, not just CF. I'd wager that the only area you don't see this problem (as much) would be java developers. The average java programmer comes from a programming background I think.
So many web developers are not CS majors by default, they maybe started out as graphic designers who learned dynamic web page development using ASP, php, CFML, etc. Relational database design isn't always the easiest concept for some people to grasp. I wasn't a cs major either, though I'd be programming all my life as a hobby (I wrote a terminal emulator for my Commodore 64 once!), I was never a disciplined programmer. Never really dealt with databases as well until 1996 when I was asked to build a cost estimating application using VB and Excel. We were a small company and our resident database specialist who was responsible for maintaining our SQL Server 6.5 installation taught my the basics of relational database design and normalization and such. She was actually very good. 10 years later, I still learn things about how best to design databases and run queries, because I work with extremely large amounts of data here at Duke... millions of rows. Bad database design doesn't always become noticable to people until you've got a lot of data and your queries start to suck. I wrote one app just recently than ran a lot of queries. It ran fine with test data until I realized that the spreadsheet I was generating had 1800 rows and I was running 22 queries for each row. That's 39,600 queries. I ended up creating a view and doing some other stuff to drop the number of queries to 3600 and it runs fine now - 5-10 seconds. Which is fine for a report that only runs once a month :) rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237192 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
