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
Hi,
Its more getting the hardware sorted than the database, you need gear capable of writing to disk at that speed and more, and with todays hardware that isn't a problem.
Even a pair of mirrored SATA disks on Windows 2003 Server will write at around 50MBytes / second.
Once you have your hardware set, personally i'd be looking at something with a couple of GB of RAM (nice big cache) and a couple of mirrored SCSI 15Krpm disks for a dedicated transaction log and a set of 4 disks scsi 15Krpm disks in a RAID 10 array.
Microsoft SQL Server 2005 is another option, workground edition which is all you'll need for that is around £2K per physical CPU if you have a lot of users or just go for CAL version which is cheaper.
You can use the new committed snapshot isolation so that writers aren't blocking readers so you won't have a contention problem.
Check out http://microsoft.com/sql for more information.
What sort of DR / high availability do you want on it? Clustering? Database mirroring??
Tony.
-- Tony Rogerson SQL Server MVP http://sqlserverfaq.com - free video tutorials <uspensky_at_gmail.com> wrote in message news:1139324525.832574.135350_at_g14g2000cwa.googlegroups.com...Received on Tue Feb 07 2006 - 12:18:54 CST
> We have a need for some sort of database package that can handle the
> following specs:
>
> Average data rate - 30 megabits/sec.
> Max # inserts - 40,000 records/sec.
>
> 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.
>
> suggestions (with links to benchmarks/info) are much appreciated
>
> thanks much
>