Re: Optimising an Oracle application for bandwidth

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 - 15:49:28 CST