Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Speed of SELECT in FoxPro 2.6a 1
- Thread starter systema
- Start date
ArevProgrammer
Programmer
Systema,
SELECT is the command to select a work area. SELECT - SQL may provide you with additional help in speeding up your
retreival of data. I'll have to check the documentation to be sure. If you have more than 500K records, you may want to
use or compile your exe to make use of Foxpro Extended. Rome was not built in a day. Be patient!
SELECT is the command to select a work area. SELECT - SQL may provide you with additional help in speeding up your
retreival of data. I'll have to check the documentation to be sure. If you have more than 500K records, you may want to
use or compile your exe to make use of Foxpro Extended. Rome was not built in a day. Be patient!
-
1
- #3
Yes if the where clause relates to a index. There is a large section in the manual on optimizing queries.
For example if you have an index on a field called lastname
the following where clauses would use rushmore:
where lastname = 'Smith'
where lastname = 'S'
the following would not
where upper(lastname) = 'SMITH'
where 'Smith' = lastname
For example if you have an index on a field called lastname
the following where clauses would use rushmore:
where lastname = 'Smith'
where lastname = 'S'
the following would not
where upper(lastname) = 'SMITH'
where 'Smith' = lastname
- Status
Similar threads
- Poll