Description of problem: At the moment, catalog will need to fetch data from both bz database and hwcert database for most of actions and it can cause some performance issues. We need to shift this to use data from hwcert database only eventually. This bug is a tracker of using hwcert db data only for public view.
Further details http://hwcert.pad.engineering.redhat.com/catalog-bz-separation
In my opinion: We should do the following steps: 1. db schema design 2. use ORM framework 3. compose utility methods(CRUD) 4. call those ORM CRUD from cigs 5. add switch for old db/new db @tfu, What do you think?
(In reply to Huan Zhang from comment #2) > In my opinion: > We should do the following steps: > 1. db schema design > 2. use ORM framework > 3. compose utility methods(CRUD) > 4. call those ORM CRUD from cigs > 5. add switch for old db/new db > > @tfu, > What do you think? I think introduce ORM for this release is a bit risk IMHO. We probably need to do some prove of concept stuff before we can move it to production.
verified on live.