Method and system for optimizing data replication for large scale archives

A non-transitory computer readable medium comprising computer readable program code, which when executed by a computer processor, enables the computer processor to:

• receive, at a secondary site comprising a first query node, a query request from a first client, wherein the query request specifies a first field comprising metadata describing a first record;
• execute the query request to obtain a first archive replica package (ARP) stored at the secondary site, wherein the first ARP comprises a first plurality of fields, wherein a second field of the first plurality of fields matches the first field;
• make a first determination that the first record is not stored at the secondary site, wherein the first record is associated with the first ARP;
• based on the first determination:
• transmit a request to a primary site comprising a second query node, wherein the primary site is located in a first geographic region and the secondary site is located in a second geographic region;
• in response to the request, receive a first archive package (AP) and the first record, wherein the first AP is associated with the first record and the first ARP;
• and
• provide the first record to the client.