Groups | Blog | Home
all groups > sql server new users > november 2004 >

sql server new users : OO and high performance needs. (Is SQL the answer ?)


Acoquinar
11/29/2004 6:53:03 AM
Greetings,

Our application is in VC++ and our business logic involves intensive
calculations on huge amounts of data.

For business reasons, we're forced to use MS SQL and not the obvious ODBMS.

We were wondering if anyone would be in the same situation and if anyone
chose to use an Object-Relational Mapper ?

P.S. Going .NET is totally out of question for us,... for obvious reasons !

Acoquinar
11/29/2004 8:23:02 AM


[quoted text, click to view]
This layer is always there ! The question is, is it reusable or not. When we
choose to have it reusable, should we implement it internally or purchase a
commercial one? With experience, once understand that buiying one is probably
the best choice.
Now for MS SQL, and under VC++,... which one is the best ? (If any !)
[quoted text, click to view]
Introducing Managed Code isn't always recommended for "Obvious" reasons.
(i.e. Performance)
[quoted text, click to view]
Acoquinar
11/29/2004 1:07:03 PM

I Do not wish to open this debate here. We did our evaluation phase and
prooved that there would be a price to pay for going toward .NET. (And i
worked with .NET and Python so i know a thing or two about Managed Code!)

Now the question is,... How can we connect our OO unmanaged code to the
relational data it uses. All that above SQL Server...

.... There has to be some O\R Mapping technologies out-there to do this job ?

We looked at EdgeXtend but it doesn't support SQL Server... We looked at
Versant OpenAccess but it's restricted to the .NET world !

Any suggestions ?


[quoted text, click to view]
Adam Machanic
11/29/2004 1:10:15 PM
[quoted text, click to view]


Many studies have been done on whether managed code is less performant
than unmanaged code, and given the current technology of managed code, the
assertion that managed code is slower boils down to nothing more than a
myth. In the early days of Java, before the garbage collectors had been
properly optimized, this may have been true. However, that is no longer the
case and today's managed code is both cheaper to develop/maintain and will
outperform unmanaged code in most(*) situations. You should do some
reasearch on this topic instead of assuming that it's an obvious choice.
There is a huge amount of research available that says the choice is
anything but.

(*) Note, unmanaged code is sometimes an appropriate choice -- which is why
C# allows you to declare "unsafe" code blocks.

--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--

Robert Fuchs
11/29/2004 5:02:38 PM
[quoted text, click to view]

using an O/R Mapper means introducing another layer and this often, but not
always, can reduce performance.
It's also depending on the O/RM implementation, of course.

[quoted text, click to view]

no, that's not obvious.

regards, Robert
AddThis Social Bookmark Button