Archives of the TeradataForum

Message Posted: Tue, 29 Jun 2004 @ 16:44:26 GMT

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

Sid,

Here's a few suggestions for implementing those types of applications on a Teradata platform:

-- Enhancements in the V2R5.0 release will be a benefit

-- Localize the database access to one or few AMPs

-- Check explain text to make sure you are getting row level locks, no table level locks

-- Consider access locking, if appropriate (row level access locking)

-- Design for parameterized SQL and cached plans

-- Smaller blocksizes are preferable

-- Be aggressive with workload management techniques

-- Consider reserving AMP worker tasks only if that's the proven bottleneck, and other techniques offer no relief

-- Avoid Access Logging if possible for such requests, use DBQL Summary level logging as an alternative

You might not know about this unless you were looking for it, but Chapter 17 (Design Issues for Tactical Queries) in the current Database Design manual (B035-1094-083A) covers these points and others in greater detail.

Thanks, --Carrie

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