RapidAnalytics - Process-Scheduler slow
Hi,
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):
Thanks,
Miguel
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):
This is not really an issue, but perhaps a suggestion for a future release of RapidAnalytics.
CREATE NONCLUSTERED INDEX [IX_ra_rel_logrecords_01] ON [dbo].[ra_rel_logrecords]
(
[recordsid] ASC
)
INCLUDE ([recordid])
Thanks,
Miguel
Find more posts tagged with
Sort by:
1 - 3 of
31
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.
Best,
Nils
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.
Best,
Nils
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.
Is there a way to automatically truncate the tables that contain the logs for scheduled executions in RapidAnalytics?
Thanks again,
Miguel