Hi all,
I have this C/S app... 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.

Please help and suggest other ways if the above not practical.


Thanks.
regards,

florence