Hi Gregg,
We used to be Oracle shop for pretty long time, but
some time ago did the same thing - looked at SAPDB.
Actually we were looking for opensource alternative to
"big gyus", but only SAPDB saticfied to our
requirements. In two words I was very pleased with
this RDBMS. We are developing Java software (very
database demanding) and it took 3 days for me to port
the whole thing to SAPDB. JDBC driver is beyond
comparison with Oracle's one (if anyone tried to work
with Oracle LOBs through JDBC will understand me).
All the performance/stress tests of the app gave very
good results. In some tests Oracle slightly
outperformed SAPDB, but we spent considerable time
tuning up Oracle schema and had only common sence
indices in SAP. Other tests SAP did better. I can't
give you any numbers, but based on our app performance
tests (there are very complicatede selects) SAP was
comparable with Oracle on performance (I guess you
always can find cases where SAPDB much slower then
Oracle and vise versa, but I didn't really run into
any problems in my testing). I didn't find any problem
with stability also - we have running pilot for some
time already and never had any problems.
SAPDB is also much easier to install and administer.
After having the pain of installing Oracle on Linux
(when one needs to manually modify some scripts to
make it actually work) it took me just 30 minutes to
have SAPDB installed up and running on the same SuSE
box.
Couple of things where SAPDB is behind (IMO):
1) Data files don't extend automatically - admin needs
to plan database grouth and allocate new datafiles as
required.
2) Standby database setup is not as stightforward and
versatile as on Oracle, but still possible.
3) Good SQL studio exists only on Windows. You can run
websql on UNIX, but it is very limited. Another way -
you can connect UNIX installed DB from Windows box.
There obviously other features which are missing in
SAPDB comparing to Oracle, but we didn't need them.
So in conclusion - I would prefer SAPDB/MaxDB over
Oracle in most of the cases.
Alexei.
--- "Houghton, Gregg" <[EMAIL PROTECTED]>
wrote:
> Hello List,
>
>
>
> Does anyone have any thoughts on Maxdb scalability,
> stability, performance
> versus Oracle? We're an Oracle shop now, but we're
> looking at Maxdb as an
> alternative. Any problems with vendor applications
> being supported on
> Maxdb?
>
> Any input would be greatly appreciated.
>
> Thanks,
>
> Gregg
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
