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?