Archives of the TeradataForum

Message Posted: Tue, 15 Apr 2003 @ 14:19:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Stuart:

I believe the reason that FastExport runs out of space is due to the fact that the AMPs build the 64K blocks to transfer the data to the client. Therefore, the rows are in SPOOL and it is building blocks at the same time. This requires more space.

My suggestion for you might be to use BTEQ. Since you are only pulling 150K rows, BTEQ will be as fast as FastExport. It is when you get closer to 500K rows where FastExport begins to really gain the speed due to the time to transfer individual rows instead of blocks (many rows).

Regards,

Mike

	<Prev	Next>		<<First	<Prev	Next>	Last>>