Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
News scoops from EssentialFox
Message
From
08/05/2002 09:46:35
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, United States
 
 
To
07/05/2002 16:50:55
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Conferences & events
Miscellaneous
Thread ID:
00649984
Message ID:
00653962
Views:
23
Hi Dragan,
Good to meet you in Kansas City.
When I do a MAX(PK) SQL statement with a network table of 250,000 records, it takes 9 seconds. That's quite a penalty for each time a user starts up.

>It is, simply because it's done low-level, somewhere in the table's header or so, so it's in a block which is already read, already has the locking mechanisms in place and generally does all the neat homework under the hood, and you don't have to worry about the stuff from the above paragraphs. While I may think that my newid() is nearly perfect (or let's say sufficiently perfect), I still know that that doesn't work perfectly in all of the situations. Native support is always better.

Said sufficiently perfect.
Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform