Everything requires more lines of code. I like CF over say PHP, it's easier and quicker to write.
I feel the same way about the SQL Server/Oracle debate. Also you have to write code for damned near everything you do with oracle, with SQL Server you can do 95% of it visually. Yes I know that tools like TOAD give you some of the same or similar functionality, but it's still easier with the SQL Server tools. Take creating large scale normalized relationships and ERDs to go with them. I can do it all in Enterprise manager, table creation, column creation, datatypes, foreign key relationships, indexes, primary key assignment. I use SS diagrams for DB architecture work all the time. TOAD just doesn't meet the same standards. Plus I find things like replication, backups and security are easier to manage. Thats without even getting into the benefits of DTS packages and their many uses. Don't get me wrong. You can do some more complex things in Oracle than you can in SQL Server, and from what I understand Oracle is still faster with large scale data sets (a million plus records). How many of us really have these hug tables though? Greg Morphis wrote: > Difficult? > > Care to elaborate? > > > On Fri, May 2, 2008 at 10:37 PM, Loathe <[EMAIL PROTECTED]> wrote: >> God, >> >> Mainly it's just a bigger pain in the ass to use oracle. >> >> You have to write all your own sequences and triggers, when in SQL >> Server you get identity fields. >> >> Also the visual tools for SQL Server are just a lot nicer. Theres more >> than that, major code differences, seems like everything is more >> difficult in Oracle. >> >> C. Hatton Humphrey wrote: >>> What is the difference between CF + MSSQL and CF + Oracle? >>> >>> Is the query structure for Oracle that much different? >>> >>> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:259690 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
