Hi all,
We are using Chilisoft ASP server 3.6.2 on Linux, with MySQL 4.0.16, and having problems with simultaneous database queries.
When we do a slow SELECT (...) in one session, and then in another session we try to SHOW PROCESSLIST, the SHOW statement waits for the SELECT to finish.
We have had similar problems before with multiple SELECTs, and have been advised to add "syncodbccalls=0" to the asp-server-3000/casp.cnfg ADO section, but that has not helped in this case. Our ADO section contains:
connectionpoolsize=25
logpath=/tmp/sql.log
connectiontimeout=-1
syncodbccalls=0
maxlongfieldlength=65535
Can anyone advise us what else to try?
Cheers, Chris.