Jump to content

Multiple Select stmts on Submission Data Page

Recommended Posts

I have a VERY complex Submission data page. Right now it's working but it's taking 8 seconds to load and 4 seconds to recalculate.

Because it is a Submission, I do not have the luxury of a view. The FoodID is passed to the DP.

Because I cannot do a single call to the table and retrieve multiple fields (I tried and was blocked), I must do individual calls for each field that I need: 3 tables, 36 calls

I am wondering if I can take this out of the DP and put this into a script, do the database calls, load the virtual fields and then put them back into play within that DP.

Any ideas?


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...