Forms performance [need help!]
From: Steve Lutter <shl9_at_cornell.edu>
Date: Wed, 28 Sep 1994 09:22:14 -0500
Message-ID: <shl9-280994092214_at_128.253.170.113>
Date: Wed, 28 Sep 1994 09:22:14 -0500
Message-ID: <shl9-280994092214_at_128.253.170.113>
Anyone who has solutions please Post and/or email to me!
Here's the problem:
A query through forms on an HP takes 9 seconds, 30-40seconds(!!!) on a Mac
Workserver and is instantaneous in SQLDBA on either machine running as a
client or on the server. I have optimized SQL preferences on, I have bumped
up the records buffered and down the number fetched. I am looking into
clustering the two tables used in the join that the select hits but I don't
think that should be neccessary because of the good speed through SQLDBA.
Any ideas people?
Steve Lutter
shl9_at_cornell.edu
Received on Wed Sep 28 1994 - 15:22:14 CET