Netsuite ODBC driver performance slow

Netsuite ODBC driver performance slow

Postby marciow1 » Wed 08 Feb 2017 23:43

I just downloaded and installed the Netsuite ODBC driver last night and I'm using it with PHP. Performance is very slow to the point that most queries time out. Only when querying tables with small number of items, I get a result. For instance, a SELECT count(*) FROM InventoryItem takes 45 seconds. A SELECT * FROM InventoryItem takes a minute. This table has 3,587 records. A SELECT count(*) FROM Customer times out. This table has 64K+ records.

Is there something wrong with my set up, or is the Netsuite database that slow? I'm used to these exact same queries to return a result immediately when running against a mySQL or MSSQL database, using PHP and the ODBC driver for mySQL or MSSQL.
marciow1
 
Posts: 1
Joined: Wed 08 Feb 2017 23:02

Re: Netsuite ODBC driver performance slow

Postby MaximG » Fri 31 Mar 2017 12:57

We will check our driver performance when working in PHP environment. For this provide the exact PHP version which you are using.
MaximG
Devart Team
 
Posts: 742
Joined: Mon 06 Jul 2015 11:34


Return to ODBC Drivers