🎉 🎉   RAPIDMINER 9.5 BETA IS OUT!!!   🎉 🎉

GRAB THE HOTTEST NEW BETA OF RAPIDMINER STUDIO, SERVER, AND RADOOP. LET US KNOW WHAT YOU THINK!

CLICK HERE TO DOWNLOAD

🦉 🎤   RapidMiner Wisdom 2020 - CALL FOR SPEAKERS   🦉 🎤

We are inviting all community members to submit proposals to speak at Wisdom 2020 in Boston.


Whether it's a cool RapidMiner trick or a use case implementation, we want to see what you have.
Form link is below and deadline for submissions is November 15. See you in Boston!

CLICK HERE TO GO TO ENTRY FORM

RapidAnalytics - Process-Scheduler slow

miguelalmiguelal Member Posts: 23 Contributor II
edited November 2018 in Help
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):

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.

Thanks,
Miguel
Tagged:

Answers

  • 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,
    Miguel
  • Nils_WoehlerNils_Woehler Member Posts: 463  Guru
    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

  • 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.