Re: sql server2005 for a change in 3TB range

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 13 Nov 2007 13:24:34 +0000
Message-ID: <7765c8970711130524i3724c22by5ad48facdeaaf539@mail.gmail.com>

On Nov 13, 2007 11:55 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:

> Hi Niall,Peter
>
> I do agree with you guys .
>
> In a 3 tier stateless environment like web does the
> locaking strategy matter any more i mean readers
> blocking writers etc ?
>

show me a serious stateless web app - i.e. one which really works with no persistence at all (the acid test is does it run unchanged with no loss of functionality on a browser with cookies disabled). I have yet to see one, seriously. I don't see how there could actually be one, you must interact with the user session in any serious application.

maintenance of session state is the *core* problem for web applications in my view.

>
> Because in a web env we normally select a column such
> as a timestamp to see if row has changed and then
> based on that we go ahead with the processing
>

isn't that just what database agnostic applications tend to do - or more commonly select the whole lot and compare values of all of the columns for all of the rows.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 13 2007 - 07:24:34 CST