On 9/19/2018 7:17 AM, edward racht wrote: > Greetings Akshat, > >> Just a word of warning if and only if the number of rows in the table >> are greater than 10k. >> >> using cangetrow to filter out just few rows will be hell of a task for >> data engine. With SQL you can achieve the same task in a much faster way. > > Based on lessons learned and experience - I can tell. > > This is news to me. Not in anything I have read in the books. > > So a datamodule should not be used for everything. There is more thought required including size of table. > > Is this correct?
No. The rowset's canGetRow is something you should consider the size of
the table, not the datamodule ... datamodules are fine.