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

From: Tony Rogerson <tonyrogerson_at_sqlserverfaq.com>
Date: Fri, 10 Feb 2006 14:41:57 -0000
Message-ID: <dsi8mu$3sj$1$8302bc10_at_news.demon.co.uk>


Right then Joel, lets have a go then.

Whats your argument?

Even on a build your own box costing around £500 can deliver over 50MBytes / second write and read speeds using Windows Server.

Go for the 64 bit version and you can get quite a few GBytes of memory, most entry level boards <£100 take 4GB of DDR.

REmember the poster said 30megabits (which I read as MBytes) and 40,000 rows per second; SQL Server will do that without problem.

SQL Server will handle TB's too, if like with ALL vendor databases, you design it properly.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Joel Garry" <joel-garry_at_home.com> wrote in message 
news:1139534059.503823.12410_at_g47g2000cwa.googlegroups.com...

> Noons said:
>
>>The OP said nothing about retention periods nor can anyone
>>extrapolate how long they will be.
>
> The OP said:
>
>>What sort of database or store could handle this load? I'm looking to
>>price out a repository, basically capturing the best bid/ask and last
>>information from all 6 option exchanges, and then have a retrieval
>>application query this data in a timely fashion.
>
> I see "repository" and "option exchanges," sounds to me like data one
> needs to keep for a long time. Unless it's some unregulated
> penny-stock exchange, or someone trying to sell a day-trading advice
> service...
>
> I didn't mean to pick on you, I meant to pick on the Windows guy.
>
> jg
> --
> _at_home.com is bogus.
> I want a blue one!
> http://www.autoweek.com/apps/pbcs.dll/article?AID=/20060206/FREE/60127003/1008/CoverStory
>
Received on Fri Feb 10 2006 - 15:41:57 CET

Original text of this message