S
steve pittman
Guest
Keith, Stefan - Thanks for making the point about the performance impact of sql authorization DDL (grant/revoke), and how it makes sense to consider this a defect. In recent releases, with features like Multi-tenancy and Table Partitioning, our db architecture has introduced new ways to manage concurrent, online schema access. The MT and TP schema locking is narrowly targeted so that it does not hamper online performance (at least, not very much we believe). We should be able to use some of these methods for sql authorization so that Grant/Revoke don't have to have so much locking impact. We will do some investigation to better understand such a change (i.e., more narrowly targeted locking). We'll consider this a performance defect. As always, hearing more about how an improvement would impact customers has a significant influence on when we implement and deliver changes! Thanks again! .....steve pittman [OE sql software architect]
Continue reading...
Continue reading...