Strictly speaking, a view contains no records. Rather it presents a, well, view of the underlying tables.
Can you tell which rows changed in the underlying tables? Do any of those tables have columns defined like this?
changetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
If so, you may be able to generate a divergent view, containing the same columns as your existing view, hat only has the rows that changed since a certain time.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…