Client Server - Long Query Times

We are running Forms 3.0 against Version 6.0 database. When we do a query on one of our larger forms on the server(MIPS system) the query takes app 5 -10 seconds. When we run the same query on a client pc (386DX-40 processor) the same query takes 30 - 40 seconds.

We know the form is to large, but because of business issues we cannot rebuild the form, we can however tune/rework the form. We also realize we should see some improvement when we migrate to version 7.0, but that is few months off, and our clients will take longer to migrate to version 7.0. The need to tune the form needs to be done quicker than the migration. If anyone has any ideas I would be most grateful.

We have some real hot forms jockies, so complicated-detailed procedures are no problem. Obviously we are not real learned when it comes to tuning issues or client-server problems, so your help will be extremely appreciated.

Thanks in advance.

Robert J. McCallister Received on Tue Jan 18 1994 - 20:06:01 CET