JDBC performance is inefficient ????

Hello,

Could anybody argues about the following statment

"JDBC performance is inefficient  "



If  you agree, say why
If you don't, tell me why please

Thanks
nawafAsked:
Who is Participating?
 
technomanConnect With a Mentor Commented:
It depends on how you view inefficient.

My answer is it is efficeint.

Here are my views:

1. If your using JDBC-ODBC bridge, you have to realize that there will be an overhead in the processing time compared to a direct connection.
2. As we all know, Java is quite slow in terms of processing, but they have come up with HotSpot runtime optimizer to optimize the processing.
3. It depends on how you have coded it, if per transaction you use a new connection, of course there will be lots of overhead in performing the connection to the database. You can do the transaction with connection pooling to lessen the connection overhead.
4. In terms of maintenance, it will be efficient because it is maintainable, only few code or even none have to be modify to migrate to another database (if you have an initialization file for customization)

Hope this satisfy your question.
0
 
nawafAuthor Commented:
Edited text of question.
0
 
nawafAuthor Commented:
Edited text of question.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Ravindra76Commented:


According to Microsoft :-

Visit this URL:

 www.microsoft.com/data/ado/adotechinfo/adovsjdbc.htm

Best tof luck.
0
 
heyhey_Commented:
technoman:

this is supposed to be a discussion, no need to lock the question.

my answer is:
What is 'inefficient' ?

btw. JDBC is standard (for database interface) - not implementation.
some specific (JDBC driver) implementations may be good, some not.
0
 
nawafAuthor Commented:
inefficient in terms of

 performance
 
 functionalities
 
 Complex data type (images, sounds,etc..)

 speed when used with applets

 Coul it be better ? How ?

Thanks
0
 
nawafAuthor Commented:


"JDBC is a very limited interface that is targeted primarily at transferring data from an SQL database to a Java client"

  Microsoft
  www.microsoft.com/data/ado/adotechinfo/adovsjdbc.htm 
0
 
heyhey_Commented:
my answer (again)

JDBC is standard for database access - not implementation.

so we CAN'T talk about performance and speed at all.  
0
All Courses

From novice to tech pro — start learning today.