1.in JDBC what is "thin" and "thick" clients2.what is difference between "thin" connection and "oci" connection

  • Interview Candidate
  • 2
  • 1816

Showing Answers 1 - 2 of 2 Answers

Raghunath

  • Nov 8th, 2005
 

I Saw the question that makes differences bet'n Thick and thin type of drivers pls send Answer 2 me

  Was this answer useful?  Yes

Lavanya

  • Jan 17th, 2006
 

hi

From Oracle's documentation states that the use of  OCI driver is for maximum performance and the Thin driver is for maximum portability.

OCI versus Thin driver timings (in milliseconds)

Metric

OCI

Thin

1,000 inserts with auto-commit

3,712

3,675

1,000 inserts with manual commit

2,613

2,594

1 insert with Statement

10

10

1,000 inserts with Statement

2,804

2,583

1 insert with PreparedStatement

113

113

1,000 inserts batched

1,482

367

SELECT

10

10

Predefined SELECT

10

10

1 insert with CallableStatement

113

117

1,000 inserts with CallableStatement

1,723

1,752

Totals

12,590

11,231

It clear for us that  Thin driver outperforms the OCI driver for every type of operation except executions of CallableStatement objects.The Thin driver has been well-tuned by Oracle's JDBC development team to perform better than its OCI counterpart

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions