Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLing over the net
Message
From
19/07/2001 10:31:00
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLing over the net
Miscellaneous
Thread ID:
00532545
Message ID:
00532545
Views:
35
I have a workstation which is doing a lot of SQL across the net. When those SQL are executed on the server where the tables reside, it's fast. However, across the net, it takes more time for the workstation to obtain the results. I am trying to optimize those queries. In most of those queries, I don't use NOFILTER. Would that be of such a help? All my SQL are optimized as per Rushmore. It's true that between PCs, I have Ethernet 10 and not 100. But, for now, we can't change cards. So, what else could I look for?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform