J
John
Hi
I am using a strongly typed dataset created by vs 2008. I have added a query
to select next record to the data adapter as below;
SELECT TOP 1 <field list>
FROM MyTable
WHERE (ID > ?)
ORDER BY ID
? is replaced by the ID of the current record.
My problem is when I fill using this query there is a noticeable about half
a second delay before data is retrieved. Is there any way to improve the
performance of this query?
Thanks
Regards
I am using a strongly typed dataset created by vs 2008. I have added a query
to select next record to the data adapter as below;
SELECT TOP 1 <field list>
FROM MyTable
WHERE (ID > ?)
ORDER BY ID
? is replaced by the ID of the current record.
My problem is when I fill using this query there is a noticeable about half
a second delay before data is retrieved. Is there any way to improve the
performance of this query?
Thanks
Regards