Rabu, 11 April 2012

RE: [MS_AccessPros] Re: Streaming lining the size of a back end database

 

Art-

That's a terrible idea if you run lots of queries that join the primary with the back end or you have Lookup properties defined in the primary table. JET (ACE) can't optimize well if the tables reside in two different databases.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

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

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art Lorenzini
Sent: Wednesday, April 11, 2012 7:54 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Streaming lining the size of a back end database

Any opinons on keeping lookup tables with the client and keeping the primary table in the backend?

With warm regards,

Arthur Lorenzini
Sioux Falls, South Dakota

________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, April 6, 2012 9:59 AM
Subject: [MS_AccessPros] Re: Streaming lining the size of a back end database

One more thing to do to your back end (although it won't have a big impact since you are not opening the back end much) is to set all Sub Datasheets to "none". Sub datasheets are like mini sub forms on a table. They can show child records for a given record in the parent table by clicking on the + to the left of the record (if the sub datasheet was set up).

The problem with them is that they add a lot of overhead to big tables. When you open a table in datasheet view all those extra fields have to load, too.

To turn them all off in all tables run my code found on my site at:
http://thatlldoit.com/codesamples.aspx#anchor4

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca

--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> I know there is probably a lot of tips on on how to boost the performance of a backend database but could you give me like the top 5.
>
> Right now I am going back through and removing all the lookups I had built into the tables and using combos on the form do the work. What else could I look at?
>
> I know this is a wide and varied topic but any help would be great.
>
> Thank you,
>
> Arthur Lorenzini
> Sioux Falls, SD
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar