Most memory-efficient way in NiFi to fetch an entire RDBMS table?

[Mike Thomsen]

We have a table with 68M records that will blow up to over 250M soon,
and need to do a full table fetch on it. What's the best practice for
efficiently doing a partial or full select on it?

Thanks,

Mike