> I am new to SAPDB. I'd like to know what the effort is to port > an existing database application from MySQL to SAPDB.
Hint (assuming you're using JDBC): use PreparedStatements as much as possible. The parsing step is rather slow in SAP DB. If you're using a connection pool, set the connection property 'cache' <http://www.sapdb.org/7.4/jdbcSapdbcEng.html#Connect_Properties>. This allows to distribute the parse overhead over multiple invocations, even if a specific statement is used only once during a servlet request. > It is a simple application with a > few tables with autokeys and simple one-to-many > relations. To access a auto generated key, use <tablename>.CURRVAL. You can either get the value explicitly (SELECT <tablename>.CURRVAL from DUAL) or use it as an expression in the VALUE list of the INSERT of the releated rows [INSERT INTO <detailtable> (..., MASTERID, ...) VALUES (..., <mastertable>.CURRVAL, ...)]. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
