# 3691 ADO DataSets Based Upon Queries on Large Tables Causes Long Delay When Opening DataSet

---

I have this table with around 450.000 records in MSSQL Server, never had a single problem obtaining records via the below query.

When I create a dataset using the dataset manager, and I enter the below Query string

SELECT * FROM PSHEETS WHERE EMPL_ID = '12345'

I then click on the preview tab to see the results, on the bottom of the form there is a label which says "Obtaining Data " it goes like that for about 30 seconds, then the label changes to Disconnected, and I see no Data results.