I am working against multiple databases. After the login of the user I show the user a selection dialog and only then I know what databases to use.
1: The codes load before the selection dialog has opened, can I change this?
2: I have to load codes from the database. Are these codes loaded per user session or per server session. If per server session I have a problem because the codes are functionally the same over the databases, but generated primary keys can be different.
Hi Bertin. Codes are meant for all users and are usually used for some sort of master data. There are also some caching mechanisms easing the load on the server. CodeTypes can be partitioned by partitionId, this is usually employed in companies with different divisions where each division has its own needs regarding master data. Probably you can use that mechanism to partition your codes per user, but I'm not sure whether it's easily possible to load them from different databases on a per partition base.