RapidAnalytics - Process-Scheduler slow

miguelalmiguelal Member Posts: 23 Contributor II
edited November 2018 in Help

We are using RapidAnalytics, and once we starting having quite a bit of processes scheduled, we noticed that the Process-Scheduler page takes quite a bit to load. We ended up creating new index on the table ra_rel_logrecords and now that page is a lot faster. This is the index we created (on SQL Server):

CREATE NONCLUSTERED INDEX [IX_ra_rel_logrecords_01] ON [dbo].[ra_rel_logrecords]
[recordsid] ASC
INCLUDE ([recordid])
This is not really an issue, but perhaps a suggestion for a future release of RapidAnalytics.



  • Options
    miguelalmiguelal Member Posts: 23 Contributor II
    I forgot to ask the main question why I created this post...

    Is there a way to automatically truncate the tables that contain the logs for scheduled executions in RapidAnalytics?

    Thanks again,
  • Options
    Nils_WoehlerNils_Woehler Member Posts: 463 Maven
    Hi Miguel,

    thanks for your hint. I've created two internal tickets for both issues. But unfortunately this also means that automatic truncating isn't possible at the moment.


  • Options
    miguelalmiguelal Member Posts: 23 Contributor II
    Thanks Nils, I guess we can always create a job on the database server that truncates those tables, and leaves only one week worth of log records.
Sign In or Register to comment.