Friends,
I have developed a multiuser VFP 7 package, its pretty fast in the starting but after i add record to the dbf file it becomes slow, Once i index it again it works fast but than it becomes slow after some records added.
It is not recommend to index every day right ! Any suggestion.
I index the file as below:
SET EXCLUSIVE ON
SELECT A
USE CARE
INDEX ON FTCODE TAG FTCODE1
INDEX ON FFIRST TAG FFIRST1
INDEX ON FLAST TAG FLAST1
SELECT B
USE STUDENT
INDEX ON FTCODE TAG FTCODE1
INDEX ON JOINGRADE+SFIRST TAG JOINGRADE1
INDEX ON SFIRST TAG SFIRST
INDEX ON STCODE TAG STCODE
Is there any better way.
I have developed a multiuser VFP 7 package, its pretty fast in the starting but after i add record to the dbf file it becomes slow, Once i index it again it works fast but than it becomes slow after some records added.
It is not recommend to index every day right ! Any suggestion.
I index the file as below:
SET EXCLUSIVE ON
SELECT A
USE CARE
INDEX ON FTCODE TAG FTCODE1
INDEX ON FFIRST TAG FFIRST1
INDEX ON FLAST TAG FLAST1
SELECT B
USE STUDENT
INDEX ON FTCODE TAG FTCODE1
INDEX ON JOINGRADE+SFIRST TAG JOINGRADE1
INDEX ON SFIRST TAG SFIRST
INDEX ON STCODE TAG STCODE
Is there any better way.