Database Administration - Page 3

My application is working with a fairly large database. Although users will never be allowed to request all of the data, different selection conditions may return wildly varying amounts of data. I'm worried that the performance of the data retrieval may be inconsistent, based on how much data is retrieved from a particular user request.

How do I limit the rows retrieved for a Power Objects report?

I want to retrieve data from a database that is not associated with any objects on a form. How do I do this?

I have a very large table that contains thousands of rows. I want to let a user insert new rows into it on a particular form without having to query the table. How can I create a recordset that is bound to a table and session so that I can quickly insert the row and then close the recordset?