Re: Forms application performance over WAN

From: Carlos Augusto Leite Netto <cnetto_at_cps.softex.br>
Date: 1996/01/02
Message-ID: <4ca9ns$5ik_at_tiete.dcc.unicamp.br>#1/1


Petri Sonkeri <petri.sonkeri_at_ac.com> wrote:
>SQL*net seems to be quite chatty and generate a lot of messages going back and
>forth. I would like to know what experience anybody might have in SQL*net
>performance over a slow network connection e.g. 64kbit/s TCP/IP connection!
>

Sorry... I don't have all answers to all questions.

I just can say that I tested SQL*Forms 3 over SQL*Net V1 (Unix to Unix) using a 9600 slip conection. Performance? Bad!!! Unusable.

I recomend you to make lots of tests before anything, despite you're going to read here.

I read that SQL*Net v2 is doing better, but I didn't test it.

Be aware to LOV; SQL*Forms usually retrieves *all* rows of the select and then filters them using the criteria you typed. It can kill the performance of your application! Try to put *aways* a "where clausule" on your LOV's select to filter the rows according to a previous typed mask (using list_values( restrict ))

Regards,

Carlos Netto
cnetto_at_cps.softex.br Received on Tue Jan 02 1996 - 00:00:00 CET

Original text of this message