How to retrieve only updated/new records since the last query in SQL?

Posted by William Choi on Stack Overflow See other posts from Stack Overflow or by William Choi
Published on 2010-12-23T08:40:45Z Indexed on 2010/12/23 8:53 UTC
Read the original article Hit count: 373

Filed under:
|
|
|

Hi all,

I was asked to design a class for caching SQL query results. Calling the class' query method will query and cache the entire set of results at the first time; afterward, each subsequence query will retrieve only the updated portion, and will merge the result into the cache. If the class is required to be generic, i.e. NO knowledge about the db and the tables, do you have any idea? Is it possible, and how to retrieve only updated/new records since the last query?

Thanks! William

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql