[AccessD] Replication Database, Speed Very Slow! SOLVED

John Skolits JSkolits at CorporateDataDesign.com
Mon Mar 10 09:55:00 CST 2003


OOOPS, forgot to tell you how it was solved.


Turns out having shared floppies or CDRoms causes a replication slow down.
Here's the article.
Thanks to Mike Kaplan the Replication and Internationalization Guru.

http://trigeminal.com/usenet/usenet013.asp

John Skolits

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of John Skolits
Sent: Monday, March 10, 2003 10:26 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Replication Database, Speed Very Slow! SOLVED




-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of John Skolits
Sent: Monday, March 10, 2003 8:08 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Replication Database, Speed Very Slow!


I'm setting up a database for replication.

I created a majority of the FE and now created a replica set.  The database
now crawls.
I have a basic form that takes <1 second to open with the non replicated
backend, and about 5 seconds with the replicated one.
Not too big a deal, but I have a complex form with subforms on a different
pages of a tab control (5 total subforms).
Used to take about 4 seconds to load. Now it's 20 seconds. 30 seconds in
design mode.

What's up? Is there a fix?

John Skolits


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list