Redirecting the data to a database other than the SoftGrid DataStore

I was working with the softgrid data store and found out that all the information regarding the application usage and all goes in to the data store, this might burden the data store quite a bit so I was thinking of redirecting the data generated for various reports to some other secondary database (may be on a different machine) instead of the primary database so as to save it from unnecessary transactions.
Now my question is, how feasible it is? How can it be done?
I have identified some stored procedures and tables related to the report generation, how feasible is it to modify those stored procedures.
Waiting for any kind of help,

0 Comments   [ + ] Show comments

Answers (1)

Posted by: kkaminsk 13 years ago
9th Degree Black Belt
The Softgrid database is incredibly straightforward but you will have to do some customization to move that data off to a different SQL datastore if you think the reporting burden is going to be that bad. I haven't seen the SQL server get terribly overloaded but then again most of my clients are not using the licening / useage feature all that much. If you need to get the data over to another then SQL replication should do it. SQL replication is already used on sites that need the same Softgrid database replicated over to different servers that are geographically seperated. The tables involved should be independant of the rest of the databases but I would have to poke into the database to give you recommendeations. I think the database is straightforward but let me know if you are having issues.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ