We recently converted a project from MySQL to SAPDB. We don't use the database for any permanent data. It is just transient information that we need to store while the application is running. The application only has about 10 tables in a single database.
Our application was written in Java so all we had to do was use a different JDBC driver and rework some SQL statements. We were using AUTO_INCREMENT in MySQL and changed them all to sequences in SAPDB. Other than that, the change over was easy. We had done some comparisons with respect to the speed of MySQL vs SAPDB, and for our particular application, MySQL was about 4x faster on inserts and queries. The speed of SAPDB was still suffcient for what we needed, so we decided to switch. Derek On Tue, 25 Feb 2003 13:16:01 +0000, "Richard Morton" <[EMAIL PROTECTED]> said: > 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? > > Is the support as good as MySQL? > > From what I can see, it is a fully featured DB engine, is it as quick as > MySQL? > > Does SAP DB follow ACID guidlines? > > I appreciate any feedback > > Thanks > > Richard > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > -- Derek M. A. Lee-Wo Email: (Home) [EMAIL PROTECTED] (Work) [EMAIL PROTECTED] "Those who will not risk cannot win" - John Paul Jones _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
