20M+ rows in MSSQL works just fine. Especially in SQL 2005 and SQL 2008. Respectfully,
Adam Phillip Churvis President Productivity Enhancement > -----Original Message----- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 03, 2008 12:02 AM > To: CF-Community > Subject: Re: Help me understand the difference... (Tech question) > > Doesn't work for me.. I wouldnt go to either.. > Yuk! > > I think if you use any DB exclusively, things just become easier with > it. > And yeah we have 20+ million row tables.. Oracle work like a charm > (properly partitioned and indexed of course). > > On Fri, May 2, 2008 at 10:54 PM, Adam Churvis > <[EMAIL PROTECTED]> wrote: > > > Mainly it's just a bigger pain in the ass to use oracle. > > > > Amen to that, brother! > > > > Oracle is kinda like Jennifer Lopez, and MSSQL is kinda like Dolly > Parton. > > > > If you're easily amazed, Jennifer Lopez does it for you at first and > you > > feel really privileged to have her perform for you. You get used to > > fetching her special spring water before each gig, and having her > scream and > > throw a phone at you and call you names if you don't deck out her > dressing > > room with her favorite flowers, even when they're not in season. > People > > tell you that you just have to deal with her quirks and take her > shit, and > > her performance will make it all worthwhile in the end. Then one day > the > > Feng Shui is slightly off, and she collapses in the corner, sobbing > and > > complaining how she just can't work under these conditions, with all > these > > idiots letting her down all the time. Then she blames it all on you. > > > > Then one day by chance you catch a Dolly Parton act. You hear her > perform, > > and you're like, "I didn't know she could really sing this well!" > Then > > later on you meet her in her dressing room, and she's genuinely sweet > to > > everyone around her, including you. Her assistant couldn't find her > spring > > water, but Dolly just says, "That's okay, honey, city juice will do > just > > fine by me. Why don't you come on over here and set yourself down > for a > > spell, 'cause honey you look plum tuckered out, too!" And the stage > manager > > sticks his head in the room and says, "Fifteen seconds, Dolly," and > Dolly > > stands up and says, "Well, folks, time to give my fans what they paid > for!" > > And she smiles real big and walks briskly out on stage with a "Hey, > y'all! > > How y'all doin'? I'm so glad you joined us here at Dollywood!" > She's > > unbelievably approachable and easy to get along with, and she > accommodates > > shortcomings like no big thing. > > > > That's about the best explanation I can think of. > > > > Respectfully, > > > > Adam Phillip Churvis > > President > > Productivity Enhancement > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:259699 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
