#1  
Old 9th September 2003, 02:18 AM
Michel
 
Posts: n/a
Default Serialized transaction question


Hi NexusDB team,

I have been monitoring the progress of NexusDb for a few months, and I
am very impressed at what you guys are doing for the Delphi community.
NexusDb combined with Delphi/CBuilder looks like the perfect match for
almost any data related application, from small to large.

Currently we have invested greatly in Pervasive.SQL having written an
application for more than 10 years with over 1 million lines of code. It
is mostly based on the legacy Btrieve API. Performance is great, so is
stability, but NexusDb is so tempting as a future and long term
alternative with its long list of advantages.

My question is on serialized transaction model, which from what I
understand is used by NexusDb.

One typical operation is to modify the price rates of many clients at a
time. Say 500 clients, 200 rates, so grossly put updating 100000 records
obviously in a transaction, because the user requests this as a single
operation, so if a failure occurs, everything must be rollbacked and
restarted.

From what I understand, a transaction on a table in NexubDB will block
others from writing/updating the same table. So if a transaction takes a
few minutes, everyone else is blocked from modifying on the tables part
of the transaction. I am correct on this assumption, and if so, is the
ability to have concurrent transactions on the same tables something
that will be looked at in the future?

With many users, this will be a bottleneck; no matter how fast NexusDb
is, everyone else has to wait. I understand the argument of making
transactions as small as possible, but even transactions in the seconds
range will have a serious impact when there are many users because of
the serialized nature.

Thanks,

Michel





Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: Explicit transaction in progress, nested transaction are not supported ... Bert Moorthaemer nexusdb.public.support.sql 13 2nd June 2008 10:58 PM
Why are Transaction not allowed in DDL Bernhard Roos nexusdb.public.support.sql 5 25th January 2006 10:11 PM
Re: Multiple changes, one transaction, with SQL Eivind Bakkestuen [NDD] nexusdb.public.support.sql 1 14th April 2004 06:02 AM
Re: Multiple changes, one transaction, with SQL Hugo Galindo nexusdb.public.support.sql 2 7th April 2004 12:05 PM
Transaction and TransIsolation Solune - Marc Pleysier nexusdb.public.discussions 0 23rd August 2003 05:50 AM


All times are GMT +11. The time now is 12:15 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.