摘要 |
A method and system for data cache with browser notification of a change in the cache and update of the browser information content from the cache. A subset of data in a larger SQL type database, in the form of a lite cache is extracted and stored in RAM. The lite cache includes a record ID and one variable, although the SQL type database typically includes a plurality of variables associated with the record ID. The lite cache is updated on a periodic basis from the SQL type database. A client browser establishes an HTTP connection with a server and loads a web page with information content including content from the lite cache. The server and client also establish a TCP socket connection to pass messages from the server to the client over the socket connection. When the lite cache is updated and it is determined that browser content from the lite cache needs update or has changed, the application server triggers transmission of a change notice message over the socket connection. Upon browser receipt of the change notice message, the browser initiates a refresh of the information content over the HTTP connection.
|