Re: differenec between odbc and sqlplus

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 24 Feb 2001 16:10:17 -0800
Message-ID: <3A984D69.2B8F1995@exesolutions.com>

> Does anybody know how ODBC differs in its connection to the database from
> Sql Plus?
> We've found that its at least twice as fast running queries from SqlPlus
> copared to executing them from a client app via ODBC.

You are mixing apples and lug nuts. SQL*Plus connects through SQL*Net ... as does ODBC. So anything run through ODBC will be slower. But slower is an inherent part of ODBC no matter what you are connecting to. Well that and insecure and not very scalable but that is another story.

In short ODBC and SQL*Plus are two entirely different things and no comparison is possible.

Daniel A. Morgan Received on Sat Feb 24 2001 - 18:10:17 CST