General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Experience with a Datawarehouse in vfp
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
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