This question is locked. New answers and comments are not allowed.
I recently started using Open Access and from what I am seeing it's pretty nice. The concern I have is that in order to do an update to a record I have to do a select. So in my app I have an edit page that has done a select to show you the values to edit, you then click save where I have to do another select and then an update. Under normal load that isn't an issue, but I am concerned about putting OpenAccess in a very high usage app with millions of transactions. That one extra select could be a big problem. Is there any way to update the record without that or do I need to do a manual update to the record to accomplish that? Have you measured performance on a large application to see what kind of impact this has?