I could do with some advice on the best way of running report type queries that take hours/days to run and generate huge results. It doesn't matter how long they take, i just want them to run in the background with low priority and not end up running out of memory. The result needs to be saved to a file (either in db or filesystem). I've looked at corb and it seems to do a similar sort of thing - would my best bet be to adapt this or can I do something purely in xqy? For example I have about 4 million docs and want to export a csv containing some elements from every document. Adding indexes to the elements has been suggested but I don't really want to do that because I'll just end up with loads of indexes for one-off queries (plus it takes about 3 days to add an index!). Anybody got any suggestions? Thanks Rob Rob Whitby Senior Developer Current Medicine Group
t: +44 (0)20 7562 2981 e: [EMAIL PROTECTED] w: www.currentmedicinegroup.com <http://www.currentmedicinegroup.com/> The contents of this e-mail (including any attachments) are confidential and may be legally privileged. If you are not the intended recipient of this e-mail, any disclosure, copying, distribution or use of its contents is strictly prohibited, and you should please notify the sender immediately and then delete it (including any attachments) from your system. The opinions expressed within this communication do not necessarily reflect the views held by Current Medicine Group. Current Medicine Group is a part of Springer Science+Business Media. VAT No. GB 823 8263 26. Registered in England and Wales No. 1952472.
_______________________________________________ General mailing list [email protected] http://xqzone.com/mailman/listinfo/general
