Hi, Am 06.04.2012 18:02, schrieb Martin Bartosch: > >> 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.
Okay. >> 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. I actually think about how we can integrate this into the database layer. So we need indexes on LOBs and joins on these LOBs. >> 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). The code is already present. We only have to fill the (static) hash INDEX_of. That's all. I will fix the second issue in my fork. The first issue needs some time for a good idea. Have a nice (and long) weekend Michael -- ___________________________________________________________________ Michael Bell Humboldt-Universitaet zu Berlin Tel.: +49 (0)30-2093 70143 ZE Computer- und Medienservice Fax: +49 (0)30-2093 70135 Unter den Linden 6 [email protected] D-10099 Berlin ___________________________________________________________________ PGP Fingerprint: 09E4 3D29 4156 2774 0F2C C643 D8BD 1918 2030 5AAB
smime.p7s
Description: S/MIME Kryptografische Unterschrift
------------------------------------------------------------------------------ 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
