We have started using netsuite - it comes with what they call 'suite analytics' which gives you access to the underlying data. This is based on oracle. The ODBC driver when you link tables requires you to select the index(s) for the given table (I honestly have not see this since foxpro and great plains before Microsoft bought them)
The issue is that some of the tables have more than 255 fields so linking the tables isn't an option. Enter the pass through query.
SELECT item_id, NAME, DISPLAYNAME FROM ITEMS
It seems super slow and flakey - I am wondering if it is because I have not specified an index field (which is item_id)
I have tried a few things like 'with(index(item_id)) which comes up with a syntax error...
am I making sense?
thanks!
sam
ps - long time since I posted on here..
The issue is that some of the tables have more than 255 fields so linking the tables isn't an option. Enter the pass through query.
SELECT item_id, NAME, DISPLAYNAME FROM ITEMS
It seems super slow and flakey - I am wondering if it is because I have not specified an index field (which is item_id)
I have tried a few things like 'with(index(item_id)) which comes up with a syntax error...
am I making sense?
thanks!
sam
ps - long time since I posted on here..