RE: VB vs. JAVA

From: <oqij4ngfcrweuh001_at_sneakemail.com>
Date: Thu, 16 Aug 2001 05:35:04 -0700
Message-ID: <F001.0036CDB6.20010816054802@fatcity.com>

someones gloating :)

thanks again chris.

-----Original Message-----

[mailto:XXXXXXXXXXXXXXXXXXXXXXXXX]

Sent: Thursday, 16 August 2001 11:23 PM

To: XXXXXXXXXXXXXXXXX

One interesting note to this.

When I was benchmarking my quicksite application, which is completely java jdbc.

Using this query:

select 100 - (sum(getmisses) / sum(gets) * 100) from sys.v_$rowcache;

I was able to get 786.3 queries in per second against the database. 10,000 in 12.8 seconds.

This is using ParsedStatement and OCI.

Granted, this is just an E450 with an A1000 quering from my laptop nothing special.

That is pretty quick for "slow" old java.

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863

-----Original Message-----

Sent: Thursday, August 16, 2001 7:51 AM
To: Multiple recipients of list ORACLE-L

Well, what you mean by speed depends on what it is you're trying to do. Big numerical computations are certainly quite slow in Java... but they are even slower in PL/SQL. Remember that a Java Virtual Machine does execute native code for many operations, such as networking.

But, what is your application doing? Is it spending most of its time executing transactions? Because Java is certainly capable of starting transactions faster than Oracle can commit them, on similar hardware. Use a profiler to work out where the Java is spending most of its time, and use the OCI8 driver instead of the Thin Client.

-----Original Message-----

Sent: Thursday, August 16, 2001 7:15 AM
To: Multiple recipients of list ORACLE-L

I hear a lot of bad things about Java, mostly in regards to speed.

I'm wondering if there's anybody out there with experience in numerous programming langauges (including Java) that wouldn't mind giving their opinion about wether or not java is the best option for the job?

ta
michael

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Guy Hammond
INET: guy.hammond_at_avt.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Christopher Spence
INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: oqij4ngfcrweuh001_at_sneakemail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message