OK,
Here's the deal, I have a network deployed app, myapp.exe on shared server drive along with all the data. In this app I keep track of time card data, which is starting to creep up there is size. (TimeHD 26000+ records, TimeItms 120,000+ records) I use a "Local View" to extract data, heres the SQL Statement:

SELECT Timehd.empid, Timehd.empname, SUM(Timeitms.regtime),;
SUM(Timeitms.overtime), SUM(Timeitms.doubletime),;
SUM(Timeitms.regtime)+SUM(Timeitms.overtime)+SUM(Timeitms.doubletime) AS 
totalhours;
 FROM prewel!timehd FULL JOIN prewel!timeitms;
ON Timehd.timecrdno = Timeitms.timecrdno;  
WHERE Timeitms.jobno == ?m.cSelectedJob; 
 GROUP BY Timehd.empid;
 ORDER BY Timehd.empid

Now in VFP (7.0 BTW) Development environment with a local copy of the data the above query executes like you'd expect "Retreived ?? records in .04 Sec." in the Nework app it runs also as expected for a Non Client/Server app. "Retreived ?? Records in .53 Sec." I know that this is because I'm dragging all the data over the wire. So I guess my question is, How do I make VFP serve data in a Client/Server type app. So that I don't have all the overhead of a "Network" app

Hope I make sense :)