bouvyd’s avatarbouvyd’s Twitter Archive—№ 2,040

  1. …in reply to @iamdylanngo
    @dylanops95 This is basically what you'll do for the replicas: have a pool of them and spread the load using some kind of proxy/connection pool. But unlike applications where each query can be routed to different database replicas in the same request, in odoo we use transactions isolation
    1. …in reply to @bouvyd
      @dylanops95 This means that all queries from the same request *must* go to the same db connection from start to finish to ensure read consistency. This is why we must declare routes as readonly or not: even if a query is itself readonly, it may belong to a request that writes later on