Regarding OCI STAGE

Saama · Post by **Saama** » Fri Jan 12, 2007 3:30 pm

Hi Gurus,
On what basis OCI STAGE has better performance than ODBC STAGE.

can anyone help me out, only it uses native base connectivity we can't say that it has better performance than ODBC. plz help me out whats the reason behind.

cheers;
saama

chulett · Post by **chulett** » Fri Jan 12, 2007 3:34 pm

Experience. Native > ODBC.

I_Server_Whale · Post by **I_Server_Whale** » Fri Jan 12, 2007 3:38 pm

You need to 'Search' before you POST. This topic has been covered many times. ODBC is a very heavy interface and it is slower than native access most of the time.

To start with, check this POST.

Whale.

Saama · Post by **Saama** » Fri Jan 12, 2007 3:50 pm

Hi Gurus,
I have searched the forum, and analyzed that ,Its because it doesn't bother to maintain the integrity of data, it doesn't search for indexes while processing.am i going in the right way.

cheer;
saama

ray.wurlod · Post by **ray.wurlod** » Fri Jan 12, 2007 4:17 pm

Completely on the wrong track.

ODBC is usually slower (a) because there are extra layers of software involved (includng but not limited to the ODBC driver manager and the ODBC driver), and (b) sometimes the ODBC way of doing things - particularly if the JET Engine is involved - is curiously inefficient (for example to select all the rows select all the keys then effect an individual select for each individual row).

For some databases, SELECT performance is not much different between the two methods.