|
|
Posted by Steve Jorgensen on 10/30/05 21:30
On Sun, 30 Oct 2005 16:59:45 GMT, "Neil" <nospam@nospam.net> wrote:
>Both table have PKs; and the join is on the PKs (the main table has a
>single-field PK; and the selections table has two field -- the corresponding
>ID value from the main table combined with the machine name).
>
>The 13 second form open time (with the 50k record selections table in the
>front end joined heterogeneously with the 50k record main table in the back
>end) is over a WAN. The LAN users get much better performance.
How many records are being returned to the form, and what kind of recordset
are you using? Is any of your links to a view? If linking to a view, did you
select a logical primary key when you created the link?
Navigation:
[Reply to this message]
|