General information
Title:
Extreme slow query performance on SQL server.
I run a query against a sql server database using SQLEXEC with the following syntax;
SELECT note_nr FROM notes WHERE note LIKE '%TEST%'
It takes big part of a minute before vfp comes back with a cursor containing twenty or so records. If I run the same query using the SQL Server query tool the response is almost immediate.
Is there anyone out there knowing how to resolve this problem?
You'd make my day !
Wilco.
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