>Assuming in my report cursor (for eg sales data), I have codes for the following :-
>1) Salesman Code
>2) Product Code
>3) Customer Code
>4) Location Code
>5) Dept Code
>6) Month
>7) Sales Invoice Number
>8) Sales Invoice Amount
>
>In getting to my final cursor, assuming SQL is used, I would have to join the cursor with 5 master files. Assuming the sales records number a quarter of a million invoices, then joining 5 tables could take a long time....
>Haven't tried that yet but my customer's database contains 400k records just for product codes alone.
>
>Would this be faster using store procedures or query to VFP and index and set relation?
>Yau
Depends on what you need. If you're getting data for many invoices that'd almost cover all of your products and others then getting tables and set relation would be faster. OTOH if you're doing this for a subset of invoices then a UDF or SP would be faster. You know your data and what you need.
Cetin