Performance and scalability: Including too many database schemas

  1. Including too many database schemas (1 messages)

    We are going to use a lot of schemas in a database. it will be like one schema for one user.

    We think that, by this approach it will be eazy for us to do data migration.


    Can any one tell us, if there are any issues/problems in including too many schemas in a single DB?

  2. it should not be a big performace issue if you are connecting to differenct schemas, as there will be only 1 schema for a user even though if you have many schemas.