by florencele » Tue, 05 Oct 2004 17:42:04
Hi all,
I have this Client/Server application... 1 of the table
consist of 1 million transaction records.
Most of the time, users interested in looking at this
year transactions.
Since we have number of txns forms querying (with passed
parameters) into this back end table, is there a way to
quicken up the the forms performance?
I have thought of 2 methods.
Method 1: We create a view from the table that contains
this year transaction records. and from vfp side use
passed parameters to further filter.
Method 2: We create the contraints checking in every
tables.
My client is Visual foxpro.
Please help and suggest other ways if the above not
practical.
Thanks.
regards,
florence
