Can anyone suggest the best approach to accessing potentially large recordset (about 30-50,000 records) over the Internet to be used to update the local VFP table? The data being pulled is in MSSQL accessible via ASP-based web page.
I've tested pulling the data from ASP-page and having the page format the data to XML and sending it the client app but it seems very slow. I then tried (without success) to have MSSQL directly create the XML using the "FOR XML" clause but haven't had success directly passing this back from my ASP page.
I think the best way is to create a text file and send the while file back to the client app where it can upload the data to a local cursor and finally update the local table. Any thoughs?
It's "my" world. You're just living in it.