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

Rabu, 28 November 2012

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

John-

Is that "main" form editing anything? When you get into the database,
does it slow them down?

Try implementing the "recordset always open" solution I suggested to see
if that helps. You might see a slowdown when the app starts and opens the
recordset, but then all other access should be at normal speeds as any new
recordsets will share the already established connection.

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@rocketmail.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Wednesday, November 28, 2012 3:24 PM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: [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

------------------------------------

Yahoo! Groups Links