Re: performance of SQL*NET ?

Chi-Sharn Wu (probe!swu) wrote:
: Hi:
: My colleague told me that SQL*NET invokes a lot of handshakings even for
: a simple query.
: We have GUI programs running on about 40 client machines simultaneously and
: each GUI uses SQL*NET over TCP/IP to do a lot of queries, however the
: performance is bad.
 

: If we use RPC as communication vehicle,
: will the performance be improved ?
: Thanks for any suggestions.

I've experimented with changing a normal (case generated) form with a lot of post-query triggers in a form based on a join view. Network traffic decreased by a factor 30 (28 packages in stead of 900). Changing the post-query functionality by calling a remote procedure did not help much since the post-query trigger will fire for each fetched record. It showed a decrease of about 100% for the network traffic though. My advice is to base the form on a join view (especially if there is much lookup data) and write the on-insert etc triggers.

Teijo Doornkamp (doornkampt_at_vertis.nl) Received on Tue Aug 01 1995 - 00:00:00 CEST