C'mon, you should see through the marketing. It's sales pitch #353, the "turn key operation". :-)
SQL is comparatively more approachable for smaller, simpler, lower load applications IMHO. With more complex and demanding applications, you just have to get more granular with your database management. That applies to ANY database system - they just need a little more TLC when you puch them harder. Eric Marlon Moyer wrote: >Yes, you very definitely could be right about the implementation >issue, but I also hold it against SQL Server for marketing to Managers >that SQL server was so easy compared to Oracle that you didn't need a >dba anymore, so that's why we've got a vb programmer who doubles as >the dba. > > >On 6/30/05, Jim Davis <[EMAIL PROTECTED]> wrote: > > >>>-----Original Message----- >>>From: Marlon Moyer [mailto:[EMAIL PROTECTED] >>>Sent: Thursday, June 30, 2005 10:55 AM >>>To: CF-Community >>>Subject: I hate SQL Server >>> >>>I am fed up with SQL Server! We've got a claims search section on our >>>internal website and the search allows you to filter on 30 different >>>columns. Currently, I'm trying to track down a condition where a >>>query is fed 4 filter columns, so 4 (blah = blah) in the where clause. >>> Currently the query runs 10 minutes, but if you change one of the >>>fields from (reserves > 0) to (reserves = 0), it runs in under 30 >>>seconds. What a steaming pile of crap sql server is! >>> >>> >>And it runs better in what database? ;^) >> >>Sorry - but it does seem like you might (just maybe-possibility) have an >>implementation issue not a software issue. >> >>Does the column have an index? Perhaps even a materialized index? >> >>Jim Davis >> >> >> >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get Instant Hacker Protection, Virus Detection, Antispam & Personal Firewall. http://www.houseoffusion.com/banners/view.cfm?bannerid=62 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:162485 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
