I caught up with Mark at the Facebook party this evening. I had a chance to talk to him not only about the change logs, but also about Kickfire and the SQL chip. He asked me what I thought about working at Kickfire and I smiled and said I love it. I think I said "I've never been able to join a billion row table to a hundred million row table, sort, group and get results back in less than a minute" and I'm sure the smile never left my face.
As far as the table change logs, he verified:
- The global transaction id will be stored in the table
- OLD and NEW rows will be available for updated rows
This is great news for Flexviews (http://flexviews.sourceforge.net).
I also spoke with the folks over at the Primebase booth about getting similar change-logging enabled for PBXT tables as well.
So far I'm enjoying the conference immensely. See you tomorrow!