Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Optimising an Oracle application for bandwidth

Re: Optimising an Oracle application for bandwidth

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 6 Nov 2001 00:48:59 +0100
Message-ID: <tue95q4aopo1b8@corp.supernews.com>


This is a WAD (working as designed)
In order to notice the end of the resultset the client will _always_ have to fetch 1 record more than is in the resultset and get ora-1403. So far so good.
The only thing that has always appalled me, is that this (and all other error messages) are sent from the server in _text form_ to the client

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address




"Anthony Fedirko" <afedirko_at_yahoo.com> wrote in message
news:1c1cbf24.0111051349.8bd515f_at_posting.google.com...

> I also noticed the "ORA-01403: no data found" in my log file after
> each query issued to an 8.1.6.1.3 database running on NT using
> sqlplus.
>
> Does anyone have more info on why this is happening?
>
> Thanks,
> Anthony Fedirko
>
> Harri Kaukovuo <harri.kaukovuo4_at_nic.fi> wrote in message
news:<9ro1q7$gef$3_at_news1.song.fi>...
> > "Mike Brodbelt" <mike@_nospam_coruscant.demon.co.uk> wrote in
> > news:9yHD7.87595$uM2.10613013_at_monolith.news.easynet.net:
> >
> > > Hi,
> > >
> > > I have an application, written in VB, that uses the Microsoft OLEDB
for
> > > Oracle drivers (and by extension, the Oracle supplied Net8 client) to
> > > communicate with an Oracle database. The application is used by 10-15
> > > users who use it as their only interface to update the information
held
> > > in the Oracle database.
> > >
> > > Most users are on the same LAN as the database server, but I have one
> > > (soon to be two) remote users. These users dial up a local ISP access
> > > point, and connect into my network via PPTP, and from there, they run
> > > the VB which talks to the database. For this user, connected at
> > > 30,600bps, application response speed is a real problem.
> > >
> > > Investigating this has shown that the main problem seems to be
> > > bandwidth, rather than latency - as some screens in the app refresh, a
> > > lot of SQL is generated, and the link is getting saturated for up to
10
> > > secs or so, leading to pretty dismal performance. Now, some time ago
> > > this database used to live on MS SQL server. It was migrated to
Oracle,
> > > and most things now run better, except this. On SQL server, the VB
> > > developer had many of the queries built as stored procedures in the
> > > database. In the process of migrating, as recommended by the Oracle
> > > documentation, he changed from this stored procedure model to
> > > generating select statements within the client application, and
sending
> > > them across the wire. This has lowered performance over a modem link
> > > compared to the SQL server version.
> > >
> > > Oracle recommends against the use of stored procedures for returning
> > > query results to a client application. With this in mind, is there any
> > > sensible course we can take to reduce the bandwidth requirements of
the
> > > application in rder to make it more responsive on such a poor
> > > connection?
> >
> > I would think the opposite. Using stored procedures should be better
> > performing in WAN.
> >
> > -- Harri
> > -----------------------------------------------------------------------
> > Anti-spam: To reply by e-mail please ERASE the "4" after kaukovuo4
Received on Mon Nov 05 2001 - 17:48:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US