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.