You’re offline. This is a read only version of the page.
75,730
I was recenlty called into a client site who was complaining that GP was running slowly. After a brief review and a few questions I was informed that they had hired a web proigramming company to develop their ecommerce web site. To my dismay this company was acccessing the GP database directly and had set up scheduled jobs to run every 2-30 minutes. My immediate suggestion was to tell them to get that company away from the production GP server. I want to setup a secondary server with a replicated copy of the GP database. That way they can slow that server down all they want and not interfere with the users on the production server. They only have about a dozen tables that they had written custom scripts to query data. What type of SQL replication would you suggest for an installtion such as this? Their database is about 20GB and we will have both servers on premise. The slowdown is really pronounced because they are joining tables on non-indexed fields. Should I replcate the entire database or just those few tables?
*This post is locked for comments
The goal of the replication is to get this web development company off the production server. They should not be querying the production server at all. I am in the process of setting up scripts to transfer the 12 tables they need onto a linked server. Over there they can knock themselves out.
As said above, type of replication will depend on what they are planning to do with the site, how orders going to come in, etc.
I have deployed one-way transaction replication on our GP databases, for reporting purposes, and it worked very well. Snapshot didn't work for us, there was an issue with one of GP stored procedures.
Be mindful of the replications going, though, when you do upgrades, adding customization, etc, as the schema is being changed.
1) You should be able to control the polling interval.
2) You should also be able to request the web site vendors to replicate only the required tables. The web site might not require the complete database replicated.
3) What type of replication is required depends how the web site is configured.
Cheers!
Sanjay
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
