Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ΄πΈ΄: Horizontally scaling a database
<Oh and I like the performance metric you put out. 2 seconds to return
a row from a billion row table. You think that is realistic? >
It may not be realistic or may be realistic. I get 600 ms response time on 1.4 billion row partitioned table with global index. So by that benchmark I was shooting for 2 sec or at the worst 4 sec. If this is not achievable with in 4 sec, we will scrap the idea and go with SAN and a beefy server.
I am already working on the idea as Thomas suggested - creating view of union of tables in all databases in the network. ( 4 for testing)
Regards
Sandeep
> To query the entire data store we used views that did unions across database
> links.
>
> Performance will be terrible, but it does what you asked for.
>
> Go out and get a bunch of Pentium III machinces surplus with 40GB hard
> drives. Load Oracle and create the identical database on each machine (just
> vary the SID). Put them all on a network and have a master machine whose
> database is nothing but views and database links.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 16 2007 - 14:49:58 CDT
![]() |
![]() |