who has experience with a datawharehouse in foxpro .
we have a lot of performance problems ;
we need to download every day (with remote views) a bunch
of data from a unix box with WINUSQLI (from TRANSOFT)

My question is.
1. How can we optimise the remote views
2.how can we optimize indexes for example

All the tables can be joined with index on 3 fields
like this


example 1
sele * from x inner join y on;
str(field1) <-integer) + '-' + field2 + '-' + str(field3) <-integer) =
str(field1) <-integer) + '-' + field2 + '-' + str(field3) <-integer)
but this is very slow the tables we are talking about are
301 MB

please can you give me some performance tips
i know that you have sys fuctions where you can see if
the sql statement is rushmore optimizable .
I know that example 1 is not rushmore optimizable

David