Hi, > is it correct that the problem is only WORKFLOW_CONTEXT_KEY?
no, it's WORKFLOW_CONTEXT_VALUE we need to index. There already is an index on the key. > Actually I think there are two problems: > > 1. (Primary) keys which include LOBs. I don't see the need for a primary key on a LOB, however, the current data model needs a normal index on some of the LOB columns. We could also work around this by addition dedicated columns that allow frequently used linking of items to a workflow, mostly CSRs, CRRs and certificates. > 2. Poor index creation. Yep. Personally, I'd be fine with a standalone SQL setup script that sets up the database and indices. I don't believe we really need to integrate it in the software itself (although it makes it easier for smaller setups). cu Martin ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ OpenXPKI-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-devel
