I have a server connect API script which has a custom query resulting in around 30k records. It takes a couple of seconds run but the info won’t update very often.
What’s the best technique for taking the resulting output and storing it in a file so it can be viewed without having to run it all again?
You can just cache the results of the server action in the local storage:
This way the server action won’t be called again on page reload.
Cool. What about if calling the script directly rather than through app connect?
The output is for a Google product feed so I’m looking for it to save the output as a static file and then that URL can be used. This is to avoid any mass running of the script (DDoS for example) which would put a huge strain on the server. The data changes so infrequently that it will probably only need to be created every few weeks.
Is there a way of sending the output to a file instead of the browser in a server connect script?
create a SC workflow that loads the data. then create a repeat for that. then within the repeat insert data into a new table into the local database.
Thanks @baub, but I don’t want to store it in a local database, I want a static file. So I basically want the output from the script to be written directly to a text file.
