DbColumn Look up question - Slow Performance
Posted on 2004-08-10
As mentioned in my earlier questions ... I am creating a report in a form with approximately 200 DbColumn lookup values from two views. When I click on the report link its takes approximately 30-60 seconds to generate the report as it is computing all those field values onto the form.
Is there a better way of writing the code to lookup values from a view?? Also to speed up the report generation.
Here is a sample code from one of the 200 lookup fields on the form:
a := @Unique(@Text(@DbColumn( "" : "NoCache" ; "" ; "VIEW-1" ; 8)));
b := @TextToNumber(a);
Thanks in advance.