Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 21 Feb 2006 16:29:27 -0800
Message-ID: <1140568154.189532@jetspin.drizzle.com>

Galen Boyer wrote:
> On Tue, 21 Feb 2006, tonyrogerson_at_sqlserverfaq.com wrote:
>

>>>Having looked at M$'s implementation in my lab my impression is that
>>
>>Please post your DDL and SQL so we can all take a look - thankyou.
>>
>>In reality they have reengineered the way a lot of things work to use
>>the Row Versioning code, online index creation/rebuild, triggers,
>>transaction isolations.

>
>
> Please post your ddl and examples of the two examples you have that show
> that SQLServer has, indeed, caught up to Oracle, inclusive of tkprof
> output.

Why stop there. How about inclusive of:

1. Advanced Query Rewrite (dbms_advanced_rewrite)
2. Online Redefinition (dbms_redefinition)
3. Resumable Transactions (dbms_resumable)
4. Workspace Management (dbms_wm)
5. Real Application Clusters
6. Conditional Compilation (dbms_preprocessor)
7. Advanced Queuing (dbms_aq)
8. Flashback ... in any of its myriad forms

I'll be dust in my grave before Microsoft catches up in any meaningful way other than marketing hyperbole.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Feb 21 2006 - 18:29:27 CST