>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

The best way to optimize remote view is to switch on using back-end stored procedures. What back-end do you use? If you want to have fast native Foxpro query then you should make it Rushmore optimizable. The idea is to have index tag expresion literally identical to Where clause of Select-SQL. In your example (sorry it looks ugly on my browser and I don't quite understand it) you should have tags on STR(FieldX) probably.