open id 

HomeDatastructures

Help with Datastructure Issues

Improve Performance of Data Source Flow Report Messages in this topic - RSS

GeeTrends
GeeTrends
Posts: 123


5/24/2022
GeeTrends
GeeTrends
Posts: 123
Hi,
I want to get my performance of speeding up reporting with something equivalent to a VIEW option like in MS SQL. I attempted to use a data structure with the different fields for the tables but this didn't seem to work as I hoped. I'm also using a few MS SQL tables as lookups. How can I get the performance improved?
0 link
maurice@decisions.com
maurice@decisions.com
Administrator
Posts: 121


5/24/2022
maurice@decisions.com
maurice@decisions.com
Administrator
Posts: 121
Hi GeeTrends,

One way to improve performance would be to create a view in the database and as an object to call the flow sourced report. To add a view in the local database, write a query to create the view 'CREATE VIEW myView AS SELECT COLUMN FROM TABLE' from either a DBMS database or the query editor. After that 'dbo.myView' will be available from the list of views in System > Integrations > Databases > LOCAL CONNECTION > Add View and Decisions will generate a step for this view. A Table can be identified for user-defined types by right-clicking the type definition, selecting Edit Defined Data Structure, and locating the Table Name property on the right-hand side.
0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software