Duplicating split forms

[speakers_86]

I have a form and a subform with the same record source. Does that mean I am running that query twice? Would it be better if I used code to set the recordsets to each other?

The reason I ask is that I have two computers connected via fiber. The computer that houses the backend runs pretty fast, but the remote computer is a bit slower. I am trying to speed it up. Thanks.

 

[vbaInet]

It may not even be related to just that one form... have you tested other forms?

 

[speakers_86]

Tested them for what? Speed?

 

[vbaInet]

Correct .

 

[speakers_86]

I tested the network itself by creating a form to create a new record in a loop. It ran for 8 hours and there were something like millions of successes with no errors. How would I test my other forms?

 

[vbaInet]

You stated,

The computer that houses the backend runs pretty fast, but the remote computer is a bit slower. I am trying to speed it up.

So whatever actions you're performing here would be the same thing you would do on other forms.

Fibre should be quick so it may be a problem with your NIC.

 

[speakers_86]

It shouldn't be, as everything is working fine. Its just when the queries run on the remote computer it is slower.

 

[vbaInet]

Have a read:

http://www.granite.ab.ca/access/performancefaq.htm

 

[speakers_86]

Thanks for that, but do you know if the query is running twice since it is the recordsource of the form and subform?

edit- oh, I see what you mean. You're saying that there is actually something wrong.

 

[vbaInet]

The form is pulling the same table data twice, one for the form and the other for the subform. But that's not the likely reason why it's slow that's why I sent you the link to go through. E.g.
- Place backend MDB on the root of the network share rather than several folders down
- Shorten the name of the backend MDB

And that was why I mentioned that you should test with another form. If other forms are being slow then it could be the NIC, the network share or how the db is setup.

 

[speakers_86]

The shared folder is
\\192.168.1.1\Shared Folder\Iris\Iris_be.mdb

or

C:\Shared Folder\Iris\Iris_be.mdb

Is this good enough?

 

[vbaInet]

It's a good shallow path so it should perform better, and try using this "\\192.168.1.1\Shared Folder\Iris\Iris_be.mdb" instead of the mapped drive "C:\etc...".

 

[speakers_86]

The UNC address is what it is and has been. I just included the C drive so you can see how far down it is in the filesystem.

 

[speakers_86]

What might be note worthy is the computer details. The local computer is XP running Office 2007. The remote is 7 running Office 2013. The network is ethernet with fiber modems in line. The frontend is an mde. MOST of the tables have subdatasheet to none. For relevant tables, the property is none. I am using DLast about five times.

 

[vbaInet]

Try it on another machine on the same network. Is it a WAN or a LAN?

 

[speakers_86]

Its a LAN. There are only two computers, and I can't change that. I edited my last post to include some more details.

 

[vbaInet]

Do you want to upload the FE? I'll see what can be changed. Just include the tables and queries that run slow. 2 or 3 fictitious records will do.

 

[speakers_86]

What I could do is try to duplicate the network using my dev computer and another computer I have.

 

[vbaInet]

Sure, go ahead!

 

[speakers_86]

Here is a heavily stripped down version. The form is frmNotes. It is the second button in the custom ribbon.