i am using apache 1.3.26 sapdb 7.3 and php using odbc_pconnect to interface php with sapdb.
before i was using odbc_connect to interface with sapdb, but the performance was unacceptable, each page that called the DB was delayed for about 3 secs, which got very annoying. so i thought the problem was i that i wasn't using persistent connections, so i did the following: 1: changed all my odbc_connects to odbc_pconnects, 2: allowed multiple connections by the same user on sapdb 3: set the sapdb timeout to 30 (does this mean 30 secs)??? 4: set the apache request_timeout to 20 (i did this because i thought the apache process should die b4 the sapdb timeout????) because i tried it with the timeout greater then the sapdb timeout and i got a "SESSION DROPPED, CONNECTION CLOSED" error after a while on my scripts... anyway, after all that, sometimes the pages would load fast, with no noticable delay, then sometimes, it would load slow again, about 3 secs delay... how can i get this to work consistently? with my users only having to experience this delay once, upon initial connection??? php is running as a module, and im using the regular sapdb odbc drivers for php. how can i speed this up? thanks in advance. - jason _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
