Quoting Richard Morton <[EMAIL PROTECTED]>: > Hi, > > My fledgling product is based around a MySQL database. I am looking to change > it to SAP DB, > > Obviously this means a bit of re-engineering work and extensive testing. I am > looking for peoples experiences of SAP DB, so that I can understand the > benefits of SAPDB and make the assessment quickly. > > Does anyone have experience of both platforms, what is your view?
When compared to mysql, sapdb biggest advantage is manageability: - it provides incremental backups which are necessary for most _big_ databases. - each database instance (a database in the mysql terminology) is a cleanly separated entity. With mysql, your settings are for all your databases, with sap, you can give 1GB of memory to a database, and 80MB to another. More important, the system tables are not shared (system tables are in the 'mysql' database with mysql). The system tables sharing done by mysql is a mess when you want a backup of _one_ database and its users. - complete jdbc driver. Some features are only emulated in the mysql one (like prepared statement, that needs database kernel support to be efficient). - no fixed directory layout : you can put your databases anywhere you want, no "all database instances are under this directory" rule > > Is the support as good as MySQL? Yes. You will find lots of sap employees on this list that will provide quick answers to your questions. Bugs are corrected pretty quickly (once reported..) > > From what I can see, it is a fully featured DB engine, is it as quick as > MySQL? yes. but it's pretty hard to compare as sapdb has much more features. > > Does SAP DB follow ACID guidlines? yes. > > I appreciate any feedback > > Thanks > > Richard > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
