There is no point in making something cross platform when you know it's always gonna run on the same platform. We develop for SQL server, we are not going to suddenly decide to downdrade everything to MySQL. Likewise we are always going to run on windows and will never suddenly starting using Linux.
-- snake -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 03 September 2005 02:12 To: CF-Talk Subject: Re: Paging through records > I'm all for building apps as infrastructure neutral as possible, I'm > sorry, this is pretty stupid. If you're going to pick the lowest > common denominator from ALL DB platforms (or even all common ones), > you're going to be hurting. Unless you're building an app for > distribution that has to run on a bunch of platforms (or building a DB > abstraction framework <cough> Isaac <cough>) Subtle. :) I guess I do tend actually to advocate some form of db abstraction layer if not necessarily mine (although I've been told that it's unusual in the CF world). But even without an abstraction layer, I would still encourage the use of methods that are cross-platform with regard to the database... not at the expense of being able to meet deadlines of course, but if there's a db-independent solution that can be implemented reasonably easily, I consider that a win because that reduces the amount of work involved in changing the database later if necessary... see below... > leverage the database wherever possible. Structure your code so that > you can replace the DB with another with a minimum of fuss should you > need to, but use your database. See. :) > Note that I'm not advocating not using caching, but rather relying on > caching just to avoid database dependance. Caching is very valuable, > and can give HUGE performance increases. Well if you've got a situation where you can both improve performance and eliminate db platform dependancy in an application (as was -- I thought the scenario I was talking about), that would be a win-win situation I would think. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217279 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
