Aggregations performance discussion

ZAM
ZAM New Altair Community Member
edited November 2024 in Community Q&A
Hello,

I was wondering which would be faster and lead to better performance, to generate aggregates for the data in Rapidminer or generate them outside using SQL or other tools then bring them into Rapidminer.

Thanks and best regards,
ZAM
Tagged:

Best Answer

  • sgenzer
    sgenzer
    Altair Employee
    edited December 2019 Answer ✓
    hello @ZAM from a speed perspective I would guess most of the time SQL is going to be much faster than RapidMiner. I would recommend you use the In-Database extension in RapidMiner and get the best of both worlds. :wink:

    As for better performance down the road, it should not matter IMHO.

    Scott

Answers

  • sgenzer
    sgenzer
    Altair Employee
    edited December 2019 Answer ✓
    hello @ZAM from a speed perspective I would guess most of the time SQL is going to be much faster than RapidMiner. I would recommend you use the In-Database extension in RapidMiner and get the best of both worlds. :wink:

    As for better performance down the road, it should not matter IMHO.

    Scott