ACCESS FEED: [MS_AccessPros] Re: Slow performance in a split database

Rabu, 28 November 2012

[MS_AccessPros] Re: Slow performance in a split database

The users are using the main form of the database. One user sits about 15 feet from me so I am assuming she is on the same network. One user is in a different city so I assumed that might be part of the issue however, I'm not sure why I take such a performance hit.

The machines should be configured the same.

John F

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> John F-
>
> But are those two users doing something different (in a different part of
> the app) than the others? Are all the machines configured the same? Do
> they all route through the same network hub? Could be a network issue.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: "jfakes.rm" <jfakes@...>
> Reply-To: <MS_Access_Professionals@yahoogroups.com>
> Date: Tuesday, November 27, 2012 2:06 AM
> To: <MS_Access_Professionals@yahoogroups.com>
> Subject: [MS_AccessPros] Re: Slow performance in a split database
>
> That's what is so strange, all of my dbs are configured the same way, I
> only have this problem with two of them.
>
> --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> wrote:
> >
> > John F-
> >
> > What is different about that one user's environment or what the user is
> > doing?
> >
> > John Viescas, Author
> > Microsoft Access 2010 Inside Out
> > Microsoft Access 2007 Inside Out
> > Microsoft Access 2003 Inside Out
> > Building Microsoft Access Applications
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> > -----Original Message-----
> > From: "jfakes.rm" <jfakes@>
> > Reply-To: <MS_Access_Professionals@yahoogroups.com>
> > Date: Monday, November 26, 2012 3:19 PM
> > To: <MS_Access_Professionals@yahoogroups.com>
> > Subject: [MS_AccessPros] Re: Slow performance in a split database
> >
> > John,
> > Thanks for the explanation, however, why is this only occuring on two of
> > my databases?
> >
> > John F
> >
> > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> > wrote:
> > >
> > > Tim-
> > >
> > > If your application has a form that opens and stays open for the
> >duration
> > > of the run, you can put something like this in the form code:
> > >
> > > Option Compare Database
> > > Option Explicit
> > > Dim db As DAO.Database, rst As DAO.Recordset
> > >
> > > Private Sub Form_Load()
> > >
> > > ' Point to this database
> > > Set db = CurrentDb
> > > ' Open any linked table and leave it open
> > > Set rst = db.OpenRecordset("SELECT * FROM LinkedTable")
> > >
> > > End Sub
> > >
> > > Private Sub Form_Close()
> > > ' Close and clean up the open recordset
> > > rst.Close
> > > Set rst = Nothing
> > > Set db = Nothing
> > > End Sub
> > >
> > >
> > > John Viescas, Author
> > > Microsoft Access 2010 Inside Out
> > > Microsoft Access 2007 Inside Out
> > > Microsoft Access 2003 Inside Out
> > > Building Microsoft Access Applications
> > > SQL Queries for Mere Mortals
> > > http://www.viescas.com/
> > > (Paris, France)
> > >
> > > -----Original Message-----
> > > From: timdbui <timdbui@>
> > > Reply-To: <MS_Access_Professionals@yahoogroups.com>
> > > Date: Saturday, November 24, 2012 2:56 PM
> > > To: <MS_Access_Professionals@yahoogroups.com>
> > > Subject: Re: [MS_AccessPros] Slow performance in a split database
> > >
> > > Dear Mr. Viescas:
> > >
> > > I have similar slowness problem. Would you please elaborate you point
> >on
> > > "open record set on the backend"? How can I do that.
> > >
> > > Thanks for your help!
> > >
> > > Tim
> > > --- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@>
> > > wrote:
> > > >
> > > > John F-
> > > >
> > > > In general, if two users have a frontend open, but neither has a
> > > >permanent
> > > > connection to the back end (like a recordset left open at startup),
> > >they
> > > > will fight each other to establish a new connection every time a new
> > > > object gets opened. The solution is to open a recordset on the
> >backend
> > > >on
> > > > startup and keep it open until exit. There will be some overhead in
> > > > opening the recordset if someone else already has the backend open,
> >but
> > > > all other connections will share the already established one.
> > > >
> > > > John Viescas, Author
> > > > Microsoft Access 2010 Inside Out
> > > > Microsoft Access 2007 Inside Out
> > > > Microsoft Access 2003 Inside Out
> > > > Building Microsoft Access Applications
> > > > SQL Queries for Mere Mortals
> > > > http://www.viescas.com/
> > > > (Paris, France)
> > > >
> > > > -----Original Message-----
> > > > From: "jfakes.rm" <jfakes@>
> > > > Reply-To: <MS_Access_Professionals@yahoogroups.com>
> > > > Date: Friday, November 23, 2012 8:32 PM
> > > > To: <MS_Access_Professionals@yahoogroups.com>
> > > > Subject: [MS_AccessPros] Slow performance in a split database
> > > >
> > > > Ok here is another one of those weird ones.
> > > >
> > > > I admin several split databases. In two of them, when I access the
> > > > database in a development frontend, I notice a huge slow down when
> > > >another
> > > > user access the database using a different frontend. In one of the
> > > > databases, I only notice when one certain user logs in. When other
> > >users
> > > > log in (again different frontend) I don't notice any issues.
> > > >
> > > > This only occurs in two databases and none of the other dbs. I
> >connect
> > > > and have them are configured the same way (same versions, connection
> > > > method etc.).
> > > >
> > > > Any idea why the slowdown on only two databases?
> > > >
> > > > John F