Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

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

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 21 Feb 2006 20:20:02 -0600
Message-ID: <umzgkyng3.fsf@rcn.com>


On Tue, 21 Feb 2006, damorgan_at_psoug.org wrote:
> 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,

Do you want to have Tony actually try it and learn for himself, or do you want him to just realize the whole exercise is completely futile. :-; Baby steps, baby steps.

-- 
Galen Boyer
Received on Tue Feb 21 2006 - 20:20:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US