A system and method for real time updating and displaying medical diagnostics data, wherein the information stored in databases comprising large amounts of sensitive data that is being updated frequently are provided herein. By using a batch table for data filtering and a snapshot table for data retrieval, the system's performance remains substantially predictable and stable regardless of the base tables' size.