I have a query which pulls things from many tables.
If I do a select top 269 from aaa, bbb, etc it returns the data back in about 2 seconds.
If I do a select top 270 from aaa, bbb, etc it returns the data back in about 8 seconds.
Does anybody know why the query takes 6 seconds longer just to return 1 more record in the query? If so, is there any db runtime value I can adjust to speed up the response time?
Many thanks,
pd123
If I do a select top 269 from aaa, bbb, etc it returns the data back in about 2 seconds.
If I do a select top 270 from aaa, bbb, etc it returns the data back in about 8 seconds.
Does anybody know why the query takes 6 seconds longer just to return 1 more record in the query? If so, is there any db runtime value I can adjust to speed up the response time?
Many thanks,
pd123