Feature Requests item #1748357, was opened at 2007-07-05 12:15 Message generated for change (Comment added) made by bendeguz 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: msqldump too slow 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 10: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 ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
