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
Regarding OCI STAGE
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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.
To start with, check this POST.
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.