Forum Discussion

andyclap's avatar
andyclap
Icon for Advocate IV rankAdvocate IV
6 years ago

Netsuite ODBC filter not folding

Hi   I'm using Power BI to report on a NetSuite database using ODBC. I'm filtering on a table with a few million rows to select a few hundred for a report. It seems that the row filter is not bei...
Need Help
andyclap's avatar
andyclap
Icon for Advocate IV rankAdvocate IV
6 years ago

Thanks Amit,

 

however as you suggested, this isn't quite the same.

I am attempting to follow the advice given around query folding (as per the links in the related question), and in theory, predicates should fold correctly improving query performance as this is a relational database source. Joins fold correctly indicating relational database folding is active. However filters are not folding, even in the simplest example which suggests an underlying problem.

 

 

 

 

andyclap's avatar
andyclap
Icon for Advocate IV rankAdvocate IV
6 years ago

I've just tested this against another NetSuite ODBC driver (CDATA), and then ODBC to a local MySQL installation.

It seems ODBC doesn't fold filters for any of these either - this is bad!

 

Is this broken? Or is ODBC just not supported for query folding of predicates?

This is really peculiar, as the one source that can handle folding demands most efficiently is a relational database!