Re: Opinions needed about the best "Middleware suite" kbmMW vs. RO\DA

From: Sol Brown (
Date: 11/17/03

Date: Mon, 17 Nov 2003 13:01:28 -0500

Hi Alessandro,

> > 2. I'm trying to figure out if those framework would give any boost to
> > performance for say an enviroment of about 20-30 users, since my app is
> > already using Chached Updates. (I guess the answer for that would be
> > try it yourself", but its hard for me, since those users are not in my
> > personal network, they are just clients using my app)
> That probabily depends on on how you code your application and what
> you use more than anything else.
> I need more information to answer this question more precisely.

My question is just in "general", is there an overall performance benefit in
n-tier over chached updates.

> > 3. I'm making heavy use of identity fields of sql server, they serve as
> > primary field, would they get refreshed when record gets posted to the
> > server?.
> We have samples that show how that can be done in two ways.

Is it just a property?, again its just that I'm used to this with sdac.

> > 4[..] I would like to
> > know if there is an official implementation for this, as well as
> "Cascading
> > updates" like, and cascading delete, so if you delete a master
> > record it deletes all detail records, and of course when you apply the
> > updates to the database, it deletes first the detail records then the
> master
> > ones?
> I am not sure why you wouldn't want to have the posted in one transaction,

I don't think that I said so :), but anyway. So how does Master/Detail work
when the primary field of the Master table is an identity field, and I want
to send to the database the whole master/detail in one transaction?, my main
question is, how does the detail records get linked to the master record
before posting the master record to the database?. I could create a
temporary value like "-1" for the master primary id, and then OnNewRecord of
the detail I could set the default value for the foriegn id to "-1" and when
I'm posting the records and the master get its "real" ID, does it
automaticly update all detail records?, and of course does all this happen
in a single transaction?

> Our schemas allow you to set all that information and, in top of that, you
> can also use our Data Dictionary to share field attributes reused accross
> many datasets. For example, imagine you have an field called PhoneNum
> should have a DisplayLabel of "Phone Number" and it is used in 20
> What you would do is create an attribute set in the Data Dictionary and
> associate that to the fields in the various Schema datasets.
> Our fields also support regular expressions.

So does this mean that you have to make an entry in the Data Dictionary for
each field in every table, and every time I use some sql -for a report or
lookup form- in order that I should'nt have to rewrite the attributes for
each field I need to select an entry of the Data Dictionary?, that sounds
like alot of pain, according what I have seen in one product for .NET from
compnentOne (I think they call DataObjects), they have something called
virtual tables, which eliminates all this hassle, you have to supply all
atrributes just once.


> --
> Best regards,
> Alessandro Federici
> RemObjects Software, Inc.