How to speed up sql performance for a huge transaction of data?

How to speed up sql performance for a huge transaction of data?

Post 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
 
 
 

How to speed up sql performance for a huge transaction of data?

Post by Uri Diman » Tue, 05 Oct 2004 17:49:01

Hi
Method1 looks good.
Also look at "Creating a Partitioned View" article in the BOL.

" XXXX@XXXXX.COM " < XXXX@XXXXX.COM >