Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

On Fri, 17 Feb 2006, srielau@xxxxxxxxxx wrote:
DA Morgan wrote:
What any and all financial systems require is the ability to produce
a result set consistent to a point-in-time ... preferably without
locking tables. Something impossible to do with previous versions of
SQL Server.
That's what timestamps are there for. You rarely need to see the
whole database in snapshot mode.

Heres an example of why I just plain mistrust this implementation. One
of the fundamental differences between Oracle and SQLServer is how they
two view locks. SQLServer view locks as a resource. Oracle views locks
as an attribute of the row in cache. SQL Server has to acquire a lock
to then subsequently lock rows for transactional purposes. Oracle never
has this overhead as well as resource limitation.

Now, look at the statement by Seirge. To acquire this read-consisent
snapshot, or, whatever MS is calling it, SQLServer still needs to worry
about resource contention. As I said, I just don't trust the
implementation of it, while I can be 100% Oracle's implementation is
100% flawless.


If you want to sum the POS data up for the day a simple WHERE clause
will do. To solve concurency issues READ COMMITTED IMHO is plenty
good. Anything beyond that is 99% religion, 1% actual requirement.


--
Galen Boyer
.

Relevant Pages

  • Re: Simple locking question.....
    ... Yes, any time you are modifying any resource, and viewing any resource ... (unless you are in READ UNCOMMITTED isolation) ... locks on viewing is variable.) ... Deadlocks come when two processes are blocking each other. ...
    (microsoft.public.sqlserver.programming)
  • Re: Resource Accumulation on SQLServer
    ... > We have a JDBC project that works with SQLServer, ... we noticed that resource useage on SQLServer ... That said, if the number of locks accumulate, then you might have a problem. ... may need to review how you close connections. ...
    (comp.lang.java.databases)
  • Re: Few questions on embedded stuff
    ... But a complex system with lots of resource locks can get into ... > locks, extensive design reviews and most of all strict discipline. ... and one of them is the use of a WDT. ...
    (comp.arch.embedded)
  • Re: Shared-memory between threads and synchronization
    ... In my project i am having different data structures ... shared memory is used for communication between processes. ... If process 1 locks resource a then resource b ...
    (comp.os.linux.development.system)
  • Re: Shareware licensing
    ... >> Locks only stop honest people anyway. ... What the cracker ... >> Veign's Resource Center ...
    (microsoft.public.vb.general.discussion)