erickroco9611
New Member
Well...
I´ve developed some programs that works among them in diferent servers, even separated for a long distance (Diferent States).
I use this only for transport (I know that there´re others ways like Plain File or XML)... anyway!! I use this for transport information across the Company´s Network.
Sometime I had a "locking" problem and I got and advice of using NO-PREFETCH in "FOR EACH" and "FIND" sentences... And believe or not it works!!!
But now I´m suffering problems with other applications, because I took this practice (Add NO-PREFETCH to all my FOR EACh and FIND sentences). The problemm is downgrade of performance.
Tha law (PROGRESS) said... "NO-PREFETCH: Specifies that only one record is sent across the network at a time. If you are accessing a remote server and do not specify this option, Progress might send more than one record from the server to the client in each network packet. Sending more than one packet may, in rare cases, create inconsistencies with Progress Version 6 or earlier."
My questions are... This really improve the Traffic on the Network? How this affect the Performance of my Applications?
Thanks in advance!!!
I´ve developed some programs that works among them in diferent servers, even separated for a long distance (Diferent States).
I use this only for transport (I know that there´re others ways like Plain File or XML)... anyway!! I use this for transport information across the Company´s Network.
Sometime I had a "locking" problem and I got and advice of using NO-PREFETCH in "FOR EACH" and "FIND" sentences... And believe or not it works!!!
But now I´m suffering problems with other applications, because I took this practice (Add NO-PREFETCH to all my FOR EACh and FIND sentences). The problemm is downgrade of performance.
Tha law (PROGRESS) said... "NO-PREFETCH: Specifies that only one record is sent across the network at a time. If you are accessing a remote server and do not specify this option, Progress might send more than one record from the server to the client in each network packet. Sending more than one packet may, in rare cases, create inconsistencies with Progress Version 6 or earlier."
My questions are... This really improve the Traffic on the Network? How this affect the Performance of my Applications?
Thanks in advance!!!