Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Access data from foxpro free tables on a linux file serv
Message
 
To
05/02/2013 14:11:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Web
Miscellaneous
Thread ID:
01565077
Message ID:
01565202
Views:
44
>Thanks for your reply. Yes, I know that FoxPro for Unx tables are the same as FoxPro for DOS tables. Mi problem is, when I access them remotely, it takes forever to show just 6 rows of data (tables are phisically hundreds of miles away).

This is because VFP pulls entire cdx files in order to look for a record. It is extremely inefficient, and is close to unusable over a slow link.

If you need to pull remote data, consider pulling from a WebService or from a SQL server (if on a LAN/WAN) so the only data that travels is your result set.

>
>
>>Foxpro for Unix tables are actually Foxpro DOS tables, so the same principles apply. Make sure that you have the proper indexes so that your SQL statements are rushmore optimizable.
>>
>>
>>
>>>Hi:
>>>
>>>I need your help on this topic. I need to get data from Foxpro free tables that are on linux servers on several states, (yes, they use FoxPro for Unix), so I need to get data from those locations into a web server. The issue on what state to get data from is already solved, our main problem is that getting data from any state is too slow, for example, I use 2 queries to get data from, the frist, gets pacient's personal data, and the second gets the pacient's programmed analysis and the results, if any at the time the query is used. Testing with data on the same web server the fist query takes 1 second, and the second query takes about 3 seconds which is for 6 rows with 20 columns each. Taking the same data to another local server (and accessing that data through Samba), the first query takes almost 30 seconds!!!, and the second query takes more than 3 minutes!!! So I tried accessing the same data thru ODBC but with almost the same results. So I imagine how long those queries would take.
>>>
>>>Can you tell me any way to get data without taking too much time?
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform