Jan Sandholm 18.Jun.13 02:42 AM a Web browser Applications Development All Releases All Platforms
I'm experiencing double bookings/going over max resource capacity in my resource reservation code. Each resource has max capacity, reservations have start and end timestamps. A view is used to lookup for existing reservations and to calculate if existing reservations + new one would exceed max capacity before accepting the new reservation. Can view be used for this kind of processing? Is it guaranteed to be 1:1 with documents after view.Refresh? It's a one instance DB, multi-user web environment, relatively busy as well. I also try to lock the code (agent) that accesses the view while calculating available capacity (concurrent agents are allowed). Is there something silly I'm doing?