Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger tables slower in VFP 8 than VFP7 ?
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Trigger tables slower in VFP 8 than VFP7 ?
Miscellaneous
Thread ID:
00721508
Message ID:
00721508
Views:
53
Hi All,
The trigger of table is it slower in VFP 8 than VFP 7?
I use Xcase 6.03 to build my tables.
The code is generated with xcase in my tables.
It is identical Code for the triggers under VFP 7 and VFP8

Here the time of VFP7 ( Coverage )
Code = Replace nlit WITH 0 In resident

0.000229,cdbmanageform,cdbmanageform.doactions,313,c:\cdbk70\common30\libs\ccustfrm.vct,13
0.000076,cdbmanageform,cdbmanageform.doactions,314,c:\cdbk70\common30\libs\ccustfrm.vct,13
0.000036,cdbmanageform,cdbmanageform.doactions,315,c:\cdbk70\common30\libs\ccustfrm.vct,13
0.007115,cdbmanageform,cdbmanageform.doactions,316,c:\cdbk70\common30\libs\ccustfrm.vct,13
0.000063,,__ri_update_resident,1619,c:\cdbk70\amline\data1\amline.dct,14
0.000027,,__ri_update_resident,1620,c:\cdbk70\amline\data1\amline.dct,14

Here the time of VFP8
0.000463,cdbmanageform,cdbmanageform.doactions,314,c:\cdbk80\common30\libs\ccustfrm.vct,9
0.000042,cdbmanageform,cdbmanageform.doactions,315,c:\cdbk80\common30\libs\ccustfrm.vct,9
0.679659,cdbmanageform,cdbmanageform.doactions,316,c:\cdbk80\common30\libs\ccustfrm.vct,9
0.009005,,__ri_update_resident,1619,c:\cdbk80\amline\data1\amline.dct,10
0.000021,,__ri_update_resident,1620,c:\cdbk80\amline\data1\amline.dct,10

What a difference!
0.679659 > 0.007115

What occurs you it?

thank you in advance.

bernhart
Next
Reply
Map
View

Click here to load this message in the networking platform