QUERY RESTRICTION FOR TIMELY AND EFFICIENT PAGING

Systems and methods are presented for retrieving records from a database and presenting them to a user through a timely and efficient query restricting process. The query request is then modified through the use of a determined partitioning field and a modified query which partitions the field relative to a partitioning value. Records are retrieved from the database. A small set of records is presented to the user, as is a prompt to retrieve more records. An application which receives query requests determines: restricting fields, partition size and whether or not the partition is within a predetermined range. The application returns a data set and receives requests for more records. Embodiments of the invention include a storage efficient solution that is particularly useful for maintaining a time efficient user response for a dynamic database.