Re: Experiences with MaxDB

> Dear MaxDB community member,
> 
> We have started a process to gather stories around
MaxDB usage in the
> community: Please tell us about your MaxDB 
experiences or plans! 

We are developing j2ee data management apps. Our main
DB was Oracle and we have ports to other DB's. We did
some research to find free DB for cheaper alternative
to "big guys" and tryed SAPDB 7.4 and MaxDB 7.5. 
(Host platform is Linux). I'm, generally, very pleased
with the results. Good things are:

- Good performance. Our stress tests showed
performance on par with tuned up Oracle.
- Pretty good SQL support. We have very complex and
big (many kilobytes) automatically generated SQL
queries and DB doesn't seem to have any problems with
it.
- Simple to use and administer. Even though out people
didn't have idea what this DB is all about they
mastered it in no time. The whole installation on
Linux takes no more then 15-20 minutes.
- Excellent JDBC driver. It is small and it works. It
took only 3 days to port the whole app (very big one)
to SAPDB.
- Mailing lists are very informative and helpfull.
- Never noticed any stability problems.

Some areas where I would like to see improvements in
future versions:
- Outer joins are extremely slow (not really slower
then Oracle ones, but still could be better).
- Only very basic setup for stand-by DB is possible.
- webdbm is not powerfull enough, and there are no
other GUI admin interfaces for Linux. Though, it is
not as important for "die hard" dba's.
- Organizational problem might be that there are not
enough people on market who would know MaxDB
administration, but as I said staff with basic DB
knowlage picks it up very quickly.

In two words I definitely would recommend this DB.

Alexei Novakov
Ladoga Software Inc.
Chief Software Architect

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx