Bugs item #1854224, was opened at 2007-12-19 17:14 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1854224&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: PF/runtime Group: Pathfinder 0.20 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) Assigned to: Nobody/Anonymous (nobody) Summary: XQ: large memory usage during multiple inserts Initial Comment: when doing many small updates in a single query on a single document, a (very) large amount of memory is used. this can be reproduced by rewriting the many subsequenced-queries in the script from bug 1854215 to a single query. MonetDB will then use at least 11GB (with oid64) of memory (that's when i killed mserver, i don't know if it will use more). the source document in which the inserts are being made is about 1M in size (plain text). peter and lefteris have seen this happen and might have more info on this. i guess it is a separate bug (or feature). note: the work-around "chopping the query into statements with less inserts per query" works for me. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1854224&group_id=56967 ------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
