Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Enhancing Performance
Message
From
21/06/2014 16:21:44
 
 
To
21/06/2014 15:27:02
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01602118
Message ID:
01602181
Views:
83
Why are you doing that? Don't have an index and the table is ALWAYS in RECNO() order.


>Processing performance has increased tremendiously. But one another issue has been created.
>Since the file size or Data is too huge sorting records by RECNO() in a cursor is taking a long time.
>
>In other words my processing time has decreased but the time taken for builting a Cursor using RECNO() as sort key and again at the end ordering it in sorkey takes a lot time.
>
>Ultimaltely the effective time of entire process has not significantly decreased, though after creation of cursor the process is very very fast.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform