Bob, Take a look at the Tech Ed 2002 PDF online at http://www.sapdb.org/pdf/teched2002.pdf There is a list of larger organistaions using SAP DB production in that document.
I'm inclined to agree with Sven regarding MySQL - It's a nice little database in itself, but it's no way comparable to SAPDB. My feeling is that you and your partner should look at the requirements of the applciation, and choose based on that. If MySQL does everything you need, go with it - but if you need the views, stored procs, transactions, fast multiuser acces, scalability, and so on, go with SAPDB (or possibly PostgreSQL). I don't want to get too off-topic, but take a look at the licensing of the various MySQL 4 versions, as well... As far as baby sitting SAPDB, there's not a lot to be done - just backups (as with anything), adding devspaces if your needs grow, and maybe an occasional update of the statistics to help the query optimizer. If you're partner is looking back over the lists and seeing problems, that's pretty normal - the people it's working well for rarely complain :-) I think you'll find it's solid in most situations. >On Sunday 24 November 2002 03:40, bob acker wrote: >> Hello SAP list folks -- >> >> I have successfully installed SAP DB 7.3 and the 7.4 database tools and >> played around a bit with some data manipulation. >> >> I would like to use SAPDB as our web database of choice -- but my partner >> is concerned about its reliability -- and the amount of dba time/effort >> needed to keep it running. He feels no one is going to pay us to baby sit >> a web database, and reliability (especially in this economy) is extremely >> important. The darn thing should just run. >> >> So my questions are addressed to folks who are using SAPDB in production >> and perhaps stressing it a bit. >> >> How reliable is the product? Does it fail? If so, where? Does it require >> DBA work to keep it running? If so, what work (I'm not talking about >> adding users -- but DBA work necessary to keep the product functioning). >> >> If there are success stories out there -- I'd like to hear them. My >> partner wants to use MySQL (reliable & fast -- but limited functionality >> for example -- no views, no stored procs)... >> >> I'd like to use something more powerful with more features (I'm not crazy >> about using C as the stored proc language -- but its nice to have views). >> >> So if you all can share your experiences -- as to reliability or the amount >> of DBA load needed to keep it running -- it would be much appreciated. >> >> Thanks! >> >> Bob Acker >> Mead, Colorado, USA. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
