> We are now running into bottlenecks and we would like to implement connection >pooling using ODBC.
What exactly are your bottlenecks? Number of concurrent connections, connection timouts? > Is Sap DB compatible with other products (e.g. SQLRelay, unixODBC) >> which (claim) to provide these facilities? > > > SAP DB works with unixODBC, once you've got your odbcinst.ini file > correctly and made a symlink from /var/spool/sql/ini/odbc.ini to the > real location of this file on any Linux system, that is /etc/odbc.ini. SAP DB should work with e.g. unixODBC connection pooling. Unfortunatly, connection pooling works only on a per process basis, you can't share connections between processes. Since Apache 1.3 is a multi process webserver connection pooling won't work as expected: You'd have a connection pool for each and every apache process. The only situation where this would make sense is when your connection overhead to the database is large - you would setup a connection pool with a maximum of one connection that gets reused. The downside would be that the total number of concurrent connections to the database would raise and be at max equal to the number of Apache Server processes running. Without investigating the reason for your bottleneck, I doubt connection pooling will buy you anything. -Andreas -- Andreas Karajannis mediaworx berlin AG Fon (0 30) 2 75 80 - 266 Fax (0 30) 2 75 80 - 200 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
