Hello,
I have a perfomance problem with a simple SQL SELECT in VFP 9:
SELECT Datei FROM ("DBCNAME!" + lcTabelle) ;
WHERE Datei = UPPER(lcPfad) ;
INTO CURSOR TMP_DOKNAME
The column DATEI is defined as C(240) and has an index on UPPER(DATEI).
The table has about 900.000 records. The SELECT above needs 3 seconds to finish.
USE DATA\DAKDOC IN 0 ALIAS TEST
SELECT TEST
SET ORDER TO DATEI
SEEK(UPPER(lcPfad))
finishes in 0 seconds. That seems to indicate that Rushmore is kicking in.
Why is Rushmore not used in the SELECT?
TIA
Gerhard
Gerhard Schmidbauer
URANUS Software GmbH