We've got a MarkLogic database used for logging certain events. I've realized recently that one of the data fields where we store access times as xs:dateTime would be much more efficient for processing if we stored data as xs:date (we need only daily granularity).
Problems are: 1. The logging database is normally updated continually; 2. The data field has an element range index in the server with data type xs:dateTime. I cannot see any good way to update the data dynamically. Instead it seems we would need to do something like this: 1. Shut down user access to prevent dynamic updates; 2. Delete the element range index on the field; 3. Process data to convert all xs:dateTime to xs:date; 4. Re-create the element range index with xs:date; 5. Restore server access. Can anyone see a better way to do this? -- David Sewell, Editorial and Technical Manager ROTUNDA, The University of Virginia Press PO Box 801079, Charlottesville, VA 22904-4318 USA Courier: 310 Old Ivy Way, Suite 302, Charlottesville VA 22903 Email: [email protected] Tel: +1 434 924 9973 Web: http://rotunda.upress.virginia.edu/ _______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
