The Artima Developer Community
Sponsored Link

Articles Forum
Database Throughput

5 replies on 1 page. Most recent reply: Jul 13, 2007 12:41 PM by Bill Pyne

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 5 replies on 1 page
Frank Sommers

Posts: 2642
Nickname: fsommers
Registered: Jan, 2002

Database Throughput Posted: Jul 3, 2007 5:30 PM
Reply to this message Reply
Advertisement
In this interview with Artima, Gemstone chief architect Jags Ramnarayan discusses the limits of database throughput, and what developers can do when their applications reach those limits:

http://www.artima.com/lejava/articles/javaone_2007_jags_ramnarayan.html

Based on your experience with the databases you've worked with, to what degree would you say typical databases really scale in terms of transaction (query and update) throughput? At what level of transaction volume would you think of clustering as a way to increase the system's throughput?


Bill Pyne

Posts: 165
Nickname: billpyne
Registered: Jan, 2007

Re: Database Throughput Posted: Jul 5, 2007 12:20 PM
Reply to this message Reply
> Based on your experience with the databases you've worked
> with, to what degree would you say typical databases
> really scale in terms of transaction (query and update)
> throughput? At what level of transaction volume would you
> think of clustering as a way to increase the system's
> throughput?

In addition to Frank's questions, I'd like to know how many applications require this kind of throughput? My belief is that the number of applications requiring this throughput is at the far right of the bell curve.

A P Clarke

Posts: 1
Nickname: apc
Registered: Jun, 2004

Re: Database Throughput Posted: Jul 6, 2007 10:22 AM
Reply to this message Reply
I was attempting to read the Jags Ramnarayan interview, but the given url just links to a blank page (well, apart from the ads and all the usual folderol around the edges). This seems to be true for the other articles too. Is there a problem with the Artima site?

Cheers, APC

Bill Venners

Posts: 2242
Nickname: bv
Registered: Jan, 2002

Re: Database Throughput Posted: Jul 6, 2007 7:07 PM
Reply to this message Reply
> I was attempting to read the Jags Ramnarayan interview,
> but the given url just links to a blank page (well, apart
> from the ads and all the usual folderol around the edges).
> This seems to be true for the other articles too. Is
> s there a problem with the Artima site?
>
> Cheers, APC

Sorry, I accidentally configured Apache with an overzealous redirect. It has been fixed. I don't like broken URLs, so I was trying to put in a redirect for a URL that people would rarely go to, and ended up temporarily breaking URLs that people are trying to get to.

Cameron Purdy

Posts: 186
Nickname: cpurdy
Registered: Dec, 2004

Re: Database Throughput Posted: Jul 10, 2007 8:52 AM
Reply to this message Reply
> In addition to Frank's questions, I'd like to know how
> many applications require this kind of throughput? My
> belief is that the number of applications requiring this
> throughput is at the far right of the bell curve.

We have quite a few customers with applications that have the "5000 events per second" requirement, and a small number over the 100,000 mark. Some of these are "peak load" numbers (e.g. markets that see bursts of activity at open and close) and some of these are sustained (non-stop load of thousands of transactions / operations / events / etc. per second).

The reasons why a database may or may not be suitable for a task isn't just raw speed. Sometimes it has to do with the isolation requirements, or the serial versus parallel nature of the workload, or the ability to partition the load, or the durability requirements, etc. A database, for example, may impose too high a cost for serial transactions against the same small set of data, due to the isolation+durability requirement. (Serial + isolated + disk durable transactions create a maximum throughput limiter tied directly to the transaction latency, and if the transactions are driven out-of-process, that latency becomes even more significant.)

Peace,

Cameron Purdy
http://www.oracle.com/technology/products/coherence/index.html

Bill Pyne

Posts: 165
Nickname: billpyne
Registered: Jan, 2007

Re: Database Throughput Posted: Jul 13, 2007 12:41 PM
Reply to this message Reply
> We have quite a few customers with applications that have
> the "5000 events per second" requirement, and a small
> number over the 100,000 mark. Some of these are "peak
> load" numbers (e.g. markets that see bursts of activity at
> open and close) and some of these are sustained (non-stop
> load of thousands of transactions / operations / events /
> etc. per second).

Thank you for the response. I haven't run into volume requirements that steep before, so it sometimes seems unreal. Still, I would like to know the percentage of data persisted applications requiring that throughput. I believe it's a small percentage but have no figures to back it up.

> The reasons why a database may or may not be suitable for
> a task isn't just raw speed. Sometimes it has to do with
> the isolation requirements, or the serial versus parallel
> nature of the workload, or the ability to partition the
> load, or the durability requirements, etc. A database, for
> example, may impose too high a cost for serial
> transactions against the same small set of data, due to
> the isolation+durability requirement. (Serial + isolated +
> disk durable transactions create a maximum throughput
> limiter tied directly to the transaction latency, and if
> the transactions are driven out-of-process, that latency
> becomes even more significant.)
>
> Peace,
>
> Cameron Purdy
> http://www.oracle.com/technology/products/coherence/index.h
> tml

Great point.

Flat View: This topic has 5 replies on 1 page
Topic: Patterns and Practice Previous Topic   Next Topic Topic: Scaling with Rich Clients


Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2014 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us