General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
How to speed up the performance of retreving the data?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only