I'm trying to make my queries more efficient in a portal by having one giant data pull that my other queries then utilize.
I am assuming there are ways to do this via foccache but I'm curious if there is another option. Is this something I should open a ticket about? Open to hearing what other people do here.
Thanks a lot as always!!This message has been edited. Last edited by: Brandon Andrathy,
In the Client admin console you can set a procedure to be run on login. With this procedure you can store data in foccache
Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
Thank you Frans,
I spoke with IBI (thanks Walter!) and looks like there is another option we can use by setting up an APP path and exporting our data via report caster on a daily basis.
Closing this out
|Powered by Social Strata|