Devart Forums

Hello,

Is there a way to limit the number of rows returned per query? I am using the TMSQuery component and for one query it is sometimes trying to return several thousand records and overall performance is degraded accordingly. If there is a setting or statement that I can fetch maybe a few hundred at a time it would really help.

Thanks,
Tom T.

You can use SELECT TOP 100 ... FROM ... statement. Also you can use FetchAll = False mode, but in this case we strongly recommend to read about this mode limitations in SDAC help.