Posted by Jerry Stuckle on 11/16/07 21:21

Mark Space wrote:
> Jerry Stuckle wrote:
>
>>
>> Just experience. No hard facts.
>
> No facts at all with all that experience? I'm a little doubtful, to
> tell the truth.
>

No hard measurements I can lay my hands on. But about 18 years of C++
experience and 10 years Java.

> How many systems/server? How were they configured? All did the web
> server and db run on the same system? If not what type of channel did
> they communicate over? Other systems involved?
>

Typically all on one system, although some were on remote systems. Comm
links were the same in both cases, so that's immaterial.

> How many queries, how big were the tables, how many rows were returned?
> How many joins were involved?
>

Biggest would have been around 200 tables, regularly joining around
15-20 tables. A hundreds of gigabytes of data. Largest table probably
had 10M rows. But again, not germane to the conversation because the
database and request were identical in both cases. This was using DB2.

>
> An experienced engineer should be able to list some facts....
>

Sure, if I went back through stuff. But I've been a consultant for 17
years now. I've worked on numerous projects during that time. And I
don't keep detailed notes when I'm done with a project. Those go to the
customer.

But I do remember one project where some big manager said it had to be
Java. They spent about a year on the project - around 25 programmers in
all. The resulting applications were so slow as to be basically
unusable. Users complained from day 1. Nothing the did could get
acceptable performance.

They ended up rewriting it in Visual C++. Now I am not a fan of MFC,
but the result was a significant decrease in response time for the user.
Enough that it was now acceptable. Note that nothing else changed -
databases, etc. were still the same.

The manager didn't actually get fired, I don't think but he wasn't with
the company for much longer.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]