Thanks for the replies... platform - The main problems is when the user submits to a PHP script looking for data...
there are several secs of a delay before any data is returned (on a local network accessing SAP DB on Linux, using SAPs ODBC )... This happens each and everytime the script is executed... With DB pooling we hoped that there would be no wait getting a connection (as there would be one available in the pool) and the data would be replied quicker. On subsequent requests for data replies would also be quicker. Will DB pooling resolve this? Thanks Liam. ----- Original Message ----- From: "Andreas Karajannis" <[EMAIL PROTECTED]> To: "Liam" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 12:37 PM Subject: Re: SAP DB and conn pool with PHP > > > 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 > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
