Help with Datastructure Issues
Improve Performance of Data Source Flow Report
GeeTrends Posts: 123
5/24/2022
|
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 Administrator Posts: 121
5/24/2022
|
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
|