Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP Tables vs SQL Server
Message
From
22/01/2000 23:39:16
 
 
To
22/01/2000 22:25:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00321142
Message ID:
00321368
Views:
30
>>If he really wants to go NT, then he should wait a month and move to Win2000.
>
>I'll pass this along. He's the cautious type. He'll wait a least a month and then longer than that if it's Win2K.

Microsoft is running their entire company on Win2K. It's much better than NT/

>
>>It's a call center. We record most of the calls.
>
>Some of my users are on the phone a lot a while they use my reservation system. They need all the speed they can get. Do you have any general tips for increasing speed?

Rushmore everything! Run the coverage analyzer if you need more speed. There are other specific coding techniques that you can use.

- In an IF or CASE statement, put the most likely condition first
- Get rid of all m.Var on the left side of an assignment (m.MyVar = 3)
- Use SCAN/ENDSCAN instead of DO WHILE NOT EOF()/SKIP/ENDDO

>
>For instance, I recently tripled the update speed in a grid by using a native grid rather than the VFE grid object and updating a cursor rather than rows of a work table.
>
>Peter
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