Hello, i am Yuval and I work with karim about our Progress problem.
Citrix\Pcanywhere will not work for us because of the slow link (128 Kbit) between the offices (i assume it will work for 2-3 users, but not more than that)
and telnet is too complicated because we need to re-write part of the Procedures for unix. (and our program has about 2500 procedures written 10 years ago)
We did some tests and one of them included sniffing the communication between the client and the server in normal operation, and the results was shocking: almost 800 KB (Bytes!) for 3 screens.
our theory is that progress work in this way:
1. client read .r file
2. client transmit .r file to the server without processing it.
3. server process the .r files and "fill" it with data.
4. server returns the entire screen to the cient.
5. client show the result.
Is our theory correct?
Anyway, after reading the post, i think that the best solution for us is to sync the 2 servers.
We can trust our link, and i can easily promise uptime of 99%, so our big problem is the sync.
How can we do it?
Can i run a specific procedure on every data update on the server?
How can i do this? can progress 6.2 process Global Events on the db?
we are plannig to upgrade anyway to a newer version of progress, and as far as i know, in the new versions of progress the DB server is an independent SQL server (MS, Oracle, etc...), so this is an optional solution, but an expensive one.
Please help us, we are trying to find a solution for more than a month and we cant see any Progress (ha
) on that problem.
Thanks
Yuval.