Hi Manjesh,
I would expect that Oracle would outperform Derby, especially on heavy
workloads (terabytes of data and thousands of concurrent users).
Hope this helps,
-Rick
On 6/19/11 10:00 PM, manjesh wrote:
Hi I am j2ee developer ,i have worked with Oracle and MySQL, I liked
Derby and have
can it be used for big enterprise applications?
Yes!
does data access and write operations gets slow down as volume of data
increases over time?
Somewhat, but you can get tens of millions of rows into a well-designed Derby
database
without any noticable slowdown.
is there any
Parallel query and multi-version read consistency are two things Oracle does
really well which are not present in Derby. Oracle also has deep
integration with storage and backup systems and a full featured management
console.
MySQL you can deploy on EC2 with one click which is a definite plus.
When a Derby select executes in the case when where is followed by
multiple conjoined AND clauses, will all the AND clauses be evaluated even
if the first one is false, in the scan?
- m.
Hi All,
Trying to get Derby to open a read only database on Amazon EC2 via a HTTP
exposed S3 bucket. This is critical and a blocker because on the cloud we
avoid using local shared mount points requiring setup on every host (i.e. We
donĀ¹t use the file system directly). Using Derby 10.8.
According to the JavaDoc, there exists a
org.apache.derby.impl.io.URLStorageFactory, which is addressed by using the
http sub
protocol. However, when I attempt to access the following URL, Derby throws an
exception:
Connection _conn_ =