General information
Category:
COM/DCOM and OLE Automation
Title:
VFP Com Object errors with ADO
Hi,
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?
Thank you in advance!
Tim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only