Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
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...Received on Fri Feb 10 2006 - 08:41:57 CST
> 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
> --
> @home.com is bogus.
> I want a blue one!
> http://www.autoweek.com/apps/pbcs.dll/article?AID=/20060206/FREE/60127003/1008/CoverStory
>