Tim-

>I have a daunting task of working with Fox tables while writing web code in VB.NET. I am using the VFPOLEDB.1 provider and seems to work well. One problem I am having is that when I run a fairly simple SQL "SELECT" command on a large table on a server, it takes over a minute to get the results back. This table has an index on it and according to MSDN, the index will be used to decrease the processing time. Well, this is still way to long and is unacceptable to the users. Does anyone have any ideas to speed this up?

To add to Kevin's question, a couple more. Is the query also sluggish running in a VFP context? Where exactly do you see the time lag? IOW, is it sluggish during the Execute?

For example, I have a case where a DataGrid takes a while to load, but it's not the query, it's some special validation of grid columns and rows - which to show, for example, that is the bottleneck.