Hi,
We are running a webshop which gets several client and product information from the SBO database. This webshop is written in PHP. The follow code is used to connect to the SBO database:
function sbo_connect() {
$vCmp=new COM("SAPbobsCOM.Company") or die ("error");
$vCmp->server = "SRV-SQL\SAP";
$vCmp->CompanyDB = "sbo_carrus";
$vCmp->username = "ties";
$vCmp->password = "50555";
$vCmp->LicenseServer = "SRV-SQL:30000";
$vCmp->DbUserName="sbo";
$vCmp->DbPassword="sbo";
$lRetCode = $vCmp->Connect;
return $vCmp;
}
This works nicely, but calling this function takes about 2.8 seconds. This makes the webshop so slow that it's hard to work with.
As a test we've installed the database on a dedicated server:
- Intel P4 3.2Ghz (Dual Core)
- 3GB RAM
- Windows Server 2003 Standard Edition, running IIS6 and PHP 5.2.5 (this is where the webshop runs on)
A "normal" connect with mssql_connect takes about 0.001 seconds, running the $vCmp=new COM("SAPbobsCOM.Company") command also. The $lRetCode = $vCmp->Connect; is the one that's taking 2.8 seconds to complete.
Allready searched off the whole internet, but I can't find anything about it. Anyone got any ideas or any experience with this issue?
Thanks in advance!