Have installed all hotfixes... and buisness units set up right by jsooy
jsooy
Wed Jul 13 07:36:07 CDT 2005
We have installed the hotfixes for the SFO client as well as the patches for
the server.
The issue is not that we are synching other peoples base records. I am only
getting about 700 accounts and 1000 records for each user. Exactly what they
should see. However , tables like CustomerAddressBase contains the
addresses for every entity in the system. So when we synch it has to deal
with 250k records in that table. Big time slow up on the system.
Still need help... anyone have any ideas?
Josh
"Henning B. Jespersen" wrote:
> Additionally I can mention, that the company mentioned in the previous
> posting, had to implement an archiving functionality, to solve their
> performance problems related to synchronising data. Heavy use of attached
> documents resulted early in the process that they ran into the 2GB offline
> limitation of the MSDE-database.
>
> Regards
> Henning B. Jespersen
> (WM-data, Denmark)
>
>
> "Henning B. Jespersen" <hejep@wmdata.com> wrote in message
> news:ujG8W44hFHA.3656@TK2MSFTNGP09.phx.gbl...
> > the only way of narrowing down the number of customers and contacts you
> > synchronise, is to use the 'only synch. data from own business unit'. If
> > the user do not use this check-box, all data the user has access to will
> > be synchronised.
> > Using the 'do not synch. documents', unfortunately does not prevent
> > documents from the ActivityMimeBase to be synchronised. this may cause
> > heavy synchronisations, if you have a lot of attachments on your
> > Activities. The only documetn table not synchronised, if you select the
> > 'do not synch' documents' is the AnnotationBase table.
> >
> > I've some expiriences with a company running Microsoft CRM 1.2 for about
> > 1½ year know. It has been our expirience, that the most synchronisation
> > performace problems has been related to attached documents.
> > For know the only way to handle the performance load related to attached
> > docs. when synchronising, is to build a more detailed Business Unit mesh
> > with less users and customers in each mesh (it's not a nice solution, and
> > does not allway fit the business processes).
> >
> >
> > "Matt Parks" <mattp65@Yax_RemoveDashAndX_xhoo.com> wrote in message
> > news:lj19d1l1it66hd7ci0ccn3la1tl6prog1p@4ax.com...
> >> Have you installed the rollup hotfix for SFO? they have made some
> >> significant
> >> improvements on the synch process. it's not perfect, but it is better.
> >>
> >> Matt Parks
> >> MVP - Microsoft CRM
> >>
> >> ----------------------------------------
> >> ----------------------------------------
> >> On Mon, 11 Jul 2005 13:40:03 -0700, "jsooy"
> >> <jsooy@discussions.microsoft.com>
> >> wrote:
> >>
> >> We are having trouble with our synching process because some of the
> >> tables in
> >> crm are being synched in their entirety.
> >>
> >> For example the CustomerAddressBase table is copied completely to every
> >> salesman's machine. Each salesman has around 1000 accounts and 2000
> >> contacts. But when we synch the customerAddressBase table contains every
> >> record regardless of which records the addresses are linked to.
> >>
> >> Is this supposed to be this way. This is causing us some major timeout
> >> issues having to run 450000 transactions instaed of 25k for each laptop.
> >>
> >> Please Help!
> >>
> >> Thanks,
> >>
> >> Josh
> >>
> >
> >
>
>
>