Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance issue Part II
Message
 
To
25/11/1996 23:52:54
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00013025
Message ID:
00013512
Views:
34
Here are the tally's and I think they support Michel's theories;

I ran the following code in 2.6a and 5.0 against a table with 5,227,700
records, and index on comp_lot and DELETED()

CLEAR
SET DELETE OFF
? TIME()+' With Delete OFF'
mcount = 0
SCAN FOR comp_lot = "CRA"
mcount = mcount + 1
ENDSCAN
? mcount
? TIME()+' With Delete OFF'

LOCATE
SET DELETE ON
? TIME()+' With Delete ON'
mcount = 0
SCAN FOR comp_lot = "CRA"
mcount = mcount + 1
ENDSCAN
? mcount
? TIME()+' With Delete ON'

2.6a produced
07:00:30 With Delete OFF
7524
07:00:38 With Delete OFF
07:00:38 With Delete ON
7524
07:00:38 With Delete ON

5.0 produced
06:54:38 With Delete OFF
7524
06:54:46 With Delete OFF
06:54:46 With Delete ON
7524
06:55:47 With Delete ON

Results indicate 2.6a and 5.0 are equal with Delete OFF
With delete ON 2.6a out performs 5.0. Set Delete does make
a difference.
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform