Page 1 of 1
MySql Interogation problem with php via odbc
Posted: Mon Apr 10, 2006 9:03 am
by omanescu
I work under Apache 2.0 server with Php and MySql (under Windows XP). I have a php script that makes a heavy interogation, by odbc, from mysql (which can take long time to complete). If two instances of this script are running no other php script can run (until one of the scripts is finished) even if the new script does not make any database access. This problem do not appear when using Microsoft Access database via odbc. Sorry for my poor english.
Thanks,
Octav.
Posted: Mon Apr 10, 2006 10:01 am
by Buddha443556
How about checking odbc.max_links (and odbc.max_persistent if your using them) in phpinfo? Default is -1, which is unlimited.
Are you using two different servers?
Welcome to phpDN!

MySql Interogation problem with php via odbc
Posted: Tue Apr 11, 2006 1:45 am
by omanescu
Buddha443556 wrote:How about checking odbc.max_links (and odbc.max_persistent if your using them) in phpinfo? Default is -1, which is unlimited.
Are you using two different servers?
Welcome to phpDN!

Hi,
odbc.max_links is unlimited and I use only one server (and all the settings are default for php,apache and mysql).
Thanks for your answer,
Octav.
Posted: Tue Apr 11, 2006 3:48 am
by AKA Panama Jack
One question...
Why are you using ODBC to connect to Mysql? This adds an extra overhead to the process that really isn't needed and will impact on server load and speed.
Posted: Tue Apr 11, 2006 4:26 am
by omanescu
AKA Panama Jack wrote:One question...
Why are you using ODBC to connect to Mysql? This adds an extra overhead to the process that really isn't needed and will impact on server load and speed.
I use ODBC for portability reason (for example: for Oracle migration,..). It is a part of a complex client-server application which will have a huge database (many GB). I use PHP only for creating reports and not for any updating or to modify the database.