Re: Again - JDBC thin vs. thick

OK, here some (unintended off-list) email exchange I had with Dennis about the topic. Thank you Dennis, I bring it on-list again.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

Carel-Jan

Don't hesitate to take this discussion back to the list. <snip>
Actually, the only thing I really liked about Don's book was that he actually performed testing and documented how he did the testing. So you can review his testing method and decide if you want to improve it for your purposes. I see a lot of "thin is faster" or "thick is faster", but no data to support the conclusion or a description of how the testing was conducted. Don's data is for Oracle9i and at least 3 years old now, so I certainly wouldn't trust the actual conclusions.

But anyway we are drifting away from your earlier point of how the connections are managed. In my case (smallish Oracle site, only 16 production databases, just use tnsnames.ora), I have only a single Weblogic administrator to deal with and he sits across the aisle from me. If we relocate a database, then he just has to create a new connection pool and switch the applications.

Good luck on deciding whether to be thick or thin.

Dennis Williams
DBA
Lifetouch, Inc.

-----Original Message-----
From: Carel-Jan Engel [mailto:cjpengel.dbalert_at_xs4all.nl] Sent: Wednesday, September 15, 2004 8:51 AM To: DENNIS WILLIAMS
Subject: RE: Again - JDBC thin vs. thick

Dennis,

Tom Kyte didn't like Don Bales' opinion:

http://asktom.oracle.com/pls/ask/f?p=4950:8:9254297599089201353::NO::F4950_P 8_DISPLAYID,F4950_P8_CRITERIA:1101233460502 I hope you get the link in one piece.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

>
> Carel-Jan
>
> I posted the following awhile back. If you can get your hands on this
> book,
> you might get some ideas from Bales on how to benchmark the thick vs.
> thin.
>
> In "Java Programming with Oracle JDBC", Don Bales actually benchmarks the
> differences. The copy here in our group seems to have taken legs, so
> recalling from memory, I recall that under some circumstances the thin is
> faster and other times the thick is faster. The differences weren't great,
> and given the hassles of setting up SQL*Net clients, thin looks good to
> me.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.

--
http://www.freelists.org/webpage/oracle-l