"Each message has its own unique ID which is passed via the URL to the Computed
Text which uses an @DBLookup to get the text for the message and display it."
I don't understand. You seem to say you open a Message form, pass it an ID in
the QString to the doc that holds your desired message, to a Lookup to that doc
(expensive!) to retrieve the actual message and display it in your message form.
Why not just make the form that holds all your messages look as you like, then
open that doc DIRECTLY from the $$Return? That should be much faster. Just to
show a nicer message if the doc isn't found?
IF you MUST do the lookup, how about doing to a PROFILE document and use
@GetProfileField? That is also faster than a straight lookup.
"Each message has its own unique ID which is passed via the URL to the Computed Text which uses an @DBLookup to get the text for the message and display it."
I don't understand. You seem to say you open a Message form, pass it an ID in the QString to the doc that holds your desired message, to a Lookup to that doc (expensive!) to retrieve the actual message and display it in your message form.
Why not just make the form that holds all your messages look as you like, then open that doc DIRECTLY from the $$Return? That should be much faster. Just to show a nicer message if the doc isn't found?
IF you MUST do the lookup, how about doing to a PROFILE document and use @GetProfileField? That is also faster than a straight lookup.