Here's an update. Turns out there's another database I need to port to XQuery. The first one was admin. The second one has attachments stored as blobs in the database, so I turned on the hex-blob option in mysqldump to get a 537MB database extract. The blobs were marked up with the attribute xsi:type="xs:hexBinary" but the xs names was not defined and MarkLogic didn't like that much. I downloaded gVIM (google said it was the best at editing large files) and appended xmlns:xs="http://www.w3.org/2001/XMLSchema"; to the root element. Now it's in the database.
So here's a question. I guess there is no index on the id attributes of this database by default, is that correct? In performing the denormalization, I'll need to be find all documents that possess an element with an id child equal to a value, say by using the xpath "//usr[id='123']". I'll need to tune the database to optimize this, yes? I'm currently reading up on MarkLogic application services database settings to see if what I need to define is a field.
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
