General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQLExpress 2008 performance
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 ?
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