Re: [Sqlrelay-discussion] is sqlrelay fasterhan sqlnet

[David M. <dav...@fi...>]

On Fri, 18 Mar 2005 00:52:20 -0800 (PST)
zhu shi song <zhu...@ya...> wrote:

> dear sir,
>   who know whether sqlrelay is faster than oracle
> sqlnet? And why?
> 
>   tks
>   zhu

SQL Relay is generally faster than sqlnet for applications which log
into and out of the database over and over such as CGI's or other web-
based applications.

In web-based applications, to display a page, it's common to log into
the database, run a query or two and log out.  It generally takes less
time for an application to connect to SQL Relay than it does for an
application to connect directly to Oracle.  Often, it takes longer
for an application to connect to Oracle than it takes to actually run
the queries. When using SQL Relay, the connect time is generally shorter
which generally makes the application faster.

Until very recently, SQL Relay suffered from some performance-degrading
oversights which caused short queries (such as single column or row
selects or inserts, updated, or deletes) to run very slowly.  I've
fixed several of the issues and the next release should perform much
better.  The most recent prerelease has a few fixes in it too and runs
much faster than the most current stable release.

Dave
dav...@fi...