Re: Replication as a Performance Enhancer?

"Neil" <nrgins@xxxxxxxxx> wrote in message
news:dtdfl.14176$yr3.918@xxxxxxxxxxxxxxxxxxxxxxx

I noticed that you said you had a split db. But you didn't confirm that
you have the front end installed on each user's local drive. I realize
that it makes little sense to have a split db otherwise; but, for the sake
of looking into all issues here, just wondering if perhaps you didn't do
that.

Yes, each user has the frontend on their individual pc.

Also note that it's possible to open a form in Data Entry mode. If your
users are just entering data, then you can give them two "modes" for the
form: View/Edit mode, and Data Entry mode.

The users (investigators) enter new cases and edit previous cases so we're
on View/Edit mode.

Or, since you only enter one record at a time, why not just turn your
form's Allow Additions property to False; give the users an Add New
button; add a record for them in the underlying recordset; and then open
the form to that single, new record for editing?

I've decided to do something like your suggestion. Instead of opening "All"
records, I'm going to either have a dropdown on the Switchboard after
selecting their territory, a name selection box whereby they select their
name and then only their cases are pulled along with a "Add New Case" button
to enter new cases. The other way would be based upon their initial logon
whereby based upon that logon, when they select their teritory from the
Switchboard, only their cases and a "Add" button appears.

So there are a few ideas for you. Bottom line: TS is a great solution; but
it's also an extreme solution, requiring a lot of time and expense to
implement. Your problem may have a simple solution. 30-40 seconds just to
type a few words is far, far outside the range of what you should be
experiencing, even on a poorly designed system. Sometimes there's a simple
solution.

I should add that the typing "slowness" also occurs sometime in Word or
Outlook, leading me to believe the network has a lot to do with it.


I recall once I had a user who was using the front end on his home
computer, and was connecting to the back end (SQL Server) over the
Internet. It took him 10 minutes just to open the program. I found that
when I distributed a copy of the MDW file to his local machine, and had
his shortcut point to that local copy, the database opened right up!

That is essentially what I've done with my "Desk" copy as described in my
initial post.

Are you saying that the slowness doesn't occur until they begin to enter
data in that second form? That entering data in the first form is fine? If
so, then please describe what's going on between these two forms. What's
their relationship? Are both forms open at the same time? Do they share
any common data? Etc.

The first form (tab) captures initially reported information in textboxes
and a memo field and the second tab captures the details of the
investigation in textboxes and a memo field. There are also four other tabs
for capturing certain types of information. What I was describing occurs in
the either one of the memo fields as the textboxes are mostly static value
dropdowns. You can imagine how typing a narrative and waiting for the words
to appear can be frustrating.

Thanks to all for the tips and thoughts...
Earl




"Earl Anderson" <isobadd@xxxxxxxxxxxxx> wrote in message
news:497bd580$0$25451$607ed4bc@xxxxxxxxx
David,
As I read Albert's article on Thin Client Technology, TS seems to be the
way to go. I will investigate the possibility in our company.
Thx...
Earl

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns9B9DD14867223f99a49ed1d0c49c5bbb2@xxxxxxxxxxxxxxxx
"Earl Anderson" <isobadd@xxxxxxxxxxxxx> wrote in
news:497badd2$0$25452$607ed4bc@xxxxxx:

'm
wondering if in effect what I'm doing is an abbreviated form of
'replication'. If that is so, would Access 'replication' be a
viable alternative for the other 6 users to "speed things up'?

No. That is not the purpose of Jet replication (though it *is* one
of the purposes of master/slave replication in a lot of other db
engines).

My recommendation would be to host the app on a Windows Terminal
Server. With an organization as large as you're in, there should be
plenty of these around, as well as the expertise to implement it and
manage it for your workgroup.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/






.

Relevant Pages

  • Re: UNKNOWN REASON (-1017)
    ... Are you running scheduled synchs in the ... > There is one memo field in the app, which I will convert to text, ... >>> indirect replication and they purchased all new equipment. ... > server pc and he also has updated software then the only common ...
    (microsoft.public.access.replication)
  • Re: 127 Column Limit
    ... new to its replication functionality. ... Am I imagining a 127 column limit to tables in a replicated ... fields, but for every memo field, it adds at least one more field. ... non-replicated database works the same as the replicated ones. ...
    (microsoft.public.access.replication)