Skip to Content
0
Former Member
Jan 08, 2008 at 01:34 PM

Slow external connection via SAPbobsCOM.Company

69 Views

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!