Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Which is the best method?
Message
From
25/11/2002 15:33:11
Raul Davila
Davila Programming Services
Toa Alta, Puerto Rico
 
 
To
25/11/2002 13:23:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00726261
Message ID:
00726629
Views:
7
I always use key and timestamps, not only for speed, but also for concurrency in multiuser environments.

As for export to ASCII -> BCC, It's good for development or transfering data, but I don't think is really usable from a user perspective.

Cheers


>Hello,
>
>just a tip if you're working with MSSQL-Server, all DML statements are considerable faster when you set WhereType = Key And TimeStamp
>in your RemoteViews, of course you need a timestamp field in your SQL-Server table for this to work, but the speed differnce is really noticeable
>
>Regards
>
>Christian
R. Davila
DBA / Network Administrator
Administracion de Fomento Comercial
Gobierno de Puerto Rico

Still waiting for FoxPro for LINUX
Previous
Reply
Map
View

Click here to load this message in the networking platform