Archives of the TeradataForum

Message Posted: Thu, 02 Jan 2014 @ 09:29:06 GMT

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

Thanks for the benefit of your experience on the Queue usage, Dieter.

I'm using your 'Stop the Queue with High Value entry' mechanism, whilst coding the Consume Stored Procedure to run forever, as also suggested.

The whole usage of Queue Tables turned out to be some much simpler than I'd expected it would be (even though I've got a lot of Procedural code around it), and it really opens up new possibilities in handling mixed workloads.

I suppose, as a mixed workload paradigm, the Queue mechanism would fit the bill, or I guess the other way would be to have a cheap Operational Database, supported by a TPump Queue mechanism.

The important thing, it seems to me, is to ensure Users have the right level of expectation from allowing updates directly into Teradata. ?The worst thing would be to give them the impression it can be an operational Database, like Oracle - it is not.

Anyway, let's look forward to an interesting New Year.

Regards

David Clough
Senior BI Database Designer

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