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.
MySql Interogation problem with php via odbc
Moderator: General Moderators
- Buddha443556
- Forum Regular
- Posts: 873
- Joined: Fri Mar 19, 2004 1:51 pm
MySql Interogation problem with php via odbc
Hi,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!
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.
- AKA Panama Jack
- Forum Regular
- Posts: 878
- Joined: Mon Nov 14, 2005 4:21 pm
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.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.