General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>I have install SQLExpress2008 on a WS2003 with 2 Gb RAM (development machine)
>>>>
>>>>When I run a query against a table with 100.000 records from the Microsoft SQl Server Managent studio:
>>>> [ Select top 1000 from sometable ]
>>>>It returns the results in less than a second.
>>>>
>>>>But when I run the same query from VFP
>>>> [ sqlexec(nHandle, "Select top 1000 from sometable ", "cur") ]
>>>>It takes for ever, more than 15 seconds.
>>>>What is the problem ?
>>>
>>>What ODBC driver are you using in VFP?
>>
>>SQL Server Native Client 10.0
>
>Did you post exact query or actual one is different?
Yes " post exact query ".
Previous
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