Re: Forms application performance over WAN
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