Archives of the TeradataForum

Message Posted: Thu, 23 Feb 2012 @ 20:29:50 GMT


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

Subj:		Re: Stored Procedures - Cursor Processing

From:		Geoffrey Rommel

Why, oh why, oh why do Stored Procedures perform so appallingly bad in Teradata, when they include Cursor processing ?

Dieter kinda answered this already, but the main reason is that a SP runs on a single PE. Since that one PE must communicate with all the AMPs, it's never going to?be as fast as an all-AMP process -- not even close.


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

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2012 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023