Subject | RE: [firebird-support] Read-write transaction within a stored proc / optimisation |
---|---|
Author | Maya Opperman |
Post date | 2010-09-06T04:58:36Z |
> (If only views would only refresh if something had been posted to affect their data...but I guess that is asking too much..)If a view had a summary total per product code, and was reading 50 000 transactions to get a particular product's total, it would be nice if it only re-read all 50 000 transactions for that product code if 50 001 or more have been posted for that same product.
>>Ann Wrote
>>Could you explain that statement a bit more? Views should reflect
>>the most recent committed data if your using read committed
>>transactions.
Like I said, I don't think it's possible, but hey, if you don't ask you don't get ;-)