MySql Interogation problem with php via odbc

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
omanescu
Forum Newbie
Posts: 3
Joined: Mon Apr 10, 2006 8:41 am

MySql Interogation problem with php via odbc

Post 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.
User avatar
Buddha443556
Forum Regular
Posts: 873
Joined: Fri Mar 19, 2004 1:51 pm

Post 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! :D
omanescu
Forum Newbie
Posts: 3
Joined: Mon Apr 10, 2006 8:41 am

MySql Interogation problem with php via odbc

Post 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! :D
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.
User avatar
AKA Panama Jack
Forum Regular
Posts: 878
Joined: Mon Nov 14, 2005 4:21 pm

Post 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.
omanescu
Forum Newbie
Posts: 3
Joined: Mon Apr 10, 2006 8:41 am

Post 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.
Post Reply