Query restriction for timely and efficient paging

A computerized system having a processor and at least one computer storage medium, for retrieving records of a database comprising:

• a client component;
• an application component coupled to said client component comprising
• (a) a user query request receiver configured to receive a query request for data from a database, wherein the data is comprised of one or more fields,
• (b) an adaptive query modifier coupled to said query request receiver configured to determine at least one first partitioning value to partition the data based on one or more partition fields in the database based on the user query request and configured to determine whether a size of the partition is within a predetermined range of size, wherein the size of the partition is determined by counting a number of records within the partition defined by the partitioning value, and
• (c) a query output subcomponent coupled to said adaptive query modifier configured to send a modified query utilizing said first partitioning value in conjunction with said query request;
• and
• a database component coupled to said application component.

A computer-implemented method of presenting records of a database to a user comprising:

• providing a user query prompt;
• producing a user query request for data from a database, wherein said data is comprised of one or more fields;
• utilizing the user query request to modify said user query request to produce a modified query, wherein the one or more fields are used to partition the data with at least one first partitioning value such that a resulting partition is determined to be of size within a predetermined range of size, wherein the size of the partition is determined by counting a number of records within the partition defined by the partitioning value;
• retrieving a set of records from a database using said modified query, wherein the set of records returned includes the number of records that may be displayed in a browser;
• and
• presenting said set of records to a user.