> > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > > Then, if it is to the extend that a join table becomes more > > efficient, it will be time to modify it and the customer who > > has new specs will pay for the necessary development. > > At the time a project is developped, it is not fair to have > > the customer pay for a more general and less efficient design > > than requested, and it is not good practice either if you the > > developper spend more time doing it this way at no charge. > > I think spending 2 or 3 minutes (literally) making an application as > flexible is possible would please any client. I don't know about your > clients, but the people I work for and do work expect more than than the > bare minimum... >
I agree with you, Mike. It doesn't sound to me like this would be a "new spec," but running into the limits imposed by a not-ideal implementation of the original spec. Some of my side work deals with auditing code done by subcontractors, and doing a "join" by using a list inside of a column instead of using a proper join would raise a flag. Relational databases are very good at, well, relating data, and it's best to let them do their job. As far as spending more/less time on the solution, I think a developer should be able to use a join table faster than managing a list. Whereas you can look up individual relationships at the database level using a join table, using a list requires fetching data, parsing it, and then fetching more data. Also, enforcing the relationship at the database level with constraints can save the time and hassle of seeing where in the string-parsing of your list you've gone wrong. -Joe -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/client/jComponents.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196610 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
