php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #12389 bad performance of odbc_free_memory with ibm db2
Submitted: 2001-07-26 02:02 UTC Modified: 2002-01-21 09:13 UTC
From: norbert dot pomaroli at databa dot at Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.6 OS: SuSe 7.1
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: norbert dot pomaroli at databa dot at
New email:
PHP Version: OS:

 

 [2001-07-26 02:02 UTC] norbert dot pomaroli at databa dot at
calling odbc_free_memory frequently causes a delay of 0.3 secs when using ibm db2 udb v7.1 (FP2)
when i do not use odbc_free_memory between calls of odbc_exec, then submitting the query takes about 0.3 secs longer or returning from a function which called odbc_exec causes the delay.

the time delay seems to be dependent on system memory, because with 384MB (and a single processor system) it is much less then with 1GB (and a dual processor system)

the same application using a mysql-database (which is identically to the db2-database) does not suffer any performance problems (and takes some 1/100 secs for the same queries), so i think the problem may be in the unified odbc-functions.
maybe this is related to the memory leak problem reported before, but i thought this should be solved in 4.0.6

i applied the limit-memory-patch and configured php-4.0.6 with:
./configure '--enable-safe-mode' '--enable-sysvsem' '--enable-sysvshm' '--enable-trans-sid' '--enable-magic-quotes' '--enable-memory-limit' '--with-ttf' '--with-imap' '--with-gd=yes' '--enable-yp' '--with-jpeg-dir=/usr' '--with-tiff-dir=/usr' '--with-config-file-path=/etc/httpd' '--with-apxs=/usr/sbin/apxs -ltiff -lnsl -lpdf -ljpeg' '--with-exec-dir=/usr/lib/apache/bin' --with-openssl --with-mcrypt '--with-ibm-db2=/home/db2inst1/sqllib' --disable-debug

additionally i use a compiled version of the php-scripts, with the zend optimizer 1.1.0, but without compiling the scripts, the problem still persists.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-01-21 09:13 UTC] kalowsky@php.net
patch submitted (took long enough, eh?).  Please test latest cvs
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Tue May 06 13:01:29 2025 UTC