I would add that our testing has shown what Daniel says to be true. Using Perl on Linux or using dotNet on Windows we find SAPDB to be one of the most unreliable and poor performing database systems :) I really wish someone would pick up the ball and focus on producing better performing drivers / xserver design. SAPDB can be used with a database, but the communications protocols seem to be unstable under high concurrency and they have a lot of overhead.
I sure hope the mySQL team does some good hard core testing (of SAPDB / MaxDB) before writing their mysql driver gateway. MySql is one of the best performing products in "low overhead frequent connects to database". P.S. to list: Would US$5000 be enough to fund someone to develop a native and stable Windows dotNet driver for SAPDB in c#? There are already ones for MySql / Postgresql. Plus the SAPDB java driver should prove a good place to learn the driver-protocol from... Stephen Gutknecht -----Original Message----- From: Dittmar, Daniel [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 5:30 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: Perl fork question > Isnt it somewhat overheaded to open a new database connection on every > fork, or was it designed for a usage like that ? Our communication layer was written with longer running sessions in mind. You could try threads, which should be possible with newer Perl versions. Or you could create one or several db client processes and pipe the data to them from the forked processes. > BTW : is there someting like a documentation of the DBTech::sapdb > modules ? You shouldn't use SAP::DBTech::sapdb as it isn't supported anymore. Use DBD::ODBC instead (http://www.sapdb.org/7.4/sap_db_program.htm). The documentation for the other Perl modules is also on that page. 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
