Netsuite ODBC driver performance slow

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
marciow1
Posts: 1
Joined: Wed 08 Feb 2017 23:02

Netsuite ODBC driver performance slow

Post by 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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Netsuite ODBC driver performance slow

Post by 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.

Post Reply