Feature Requests item #1748357, was opened at 2007-07-05 14:15 Message generated for change (Settings changed) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1748357&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: SQL - general Group: None Status: Open Priority: 5 Private: No Submitted By: Niels Nes (nielsnes) Assigned to: Sjoerd Mullender (sjoerd) >Summary: SQL: msqldump too slow, requires server side rendering Initial Comment: Currently msqldump uses mapi_slice_row for each data row its outputing. Mapi_slice_row does a malloc/copy for each data field. This afcourse is far from optimal. A possible solution would be to let the sql server dump directly in a format which can be used for loading. Then msqldump should only pass the data directly from the server stream into the output stream. This probably requires an new set output feature too sql. ---------------------------------------------------------------------- Comment By: bendeguz (bendeguz) Date: 2007-07-08 12:29 Message: Logged In: YES user_id=1140413 Originator: NO Perhaps the column (or column slice) at a time method would help here. Please consider the parallel dump/load operation too (eg.: with MAL) - multi-core processors are pretty common today. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1748357&group_id=56967 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
