In a database system comprising at least one client connected via a network to at least one server, a method for processing a query from a particular client, said query specifying fetching of data records, the method comprising:
- receiving an initial request comprising a query from the particular client for fetching data records, said query specifying a query condition which data records must meet in order to be fetched, said client able to receive a maximum number of data records at one time;
- fetching data records meeting said query condition;
- sending to the particular client an initial set of data records from said fetched data records, said initial set having a number of data records equal to or less than said maximum number of data records;
- suspending processing of the query until a subsequent request for more data records satisfying the query is received from the particular client, said suspending step maintaining information describing the query in process;
- receiving such a subsequent request from the particular client for more data records;
- and
- sending to the particular client a subsequent set of data records from said fetched data records, said subsequent set having a number of data records equal to or less than said maximum number of data records.