We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

Data server API for create index

Answered
TWiRote asked on November 2, 2022

I using FlexMonster Pivot with dynamic data. Each user will have a specific dataset based on his selection of pivot parameters. This dataset is stored in our database.
I would like connect to a data source Microsoft SQL using Flexmonster Data Server and I would like create indexes on the Data Server dynamically.
Do you provide APIs that can be called from our application in order to create the indexes? If yes, do provide references. If no, please provide an idea on how this can be done?

2 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 2, 2022

Hello,

Thank you for reaching out to us.

We want to explain how Flexmonster Data Server works. Kindly note that Flexmonster Data Server stores all the created indexes in your RAM. So the more indexes are created, the more RAM is needed for the Data Server. In your case, each user may have a specific dataset. If those datasets have a lot of data and unique members, you may need more RAM. Using Flexmonster Data Server is not the best solution for such a case.
However, we recommend considering one of the alternative approaches:

Please let us know if it works for you. Feel free to contact us if other questions arise.

Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 16, 2022

Hello,

Hope you are doing well.

We were wondering if you had a chance to check the suggested approaches.

Looking forward to hearing your feedback.

Kind regards,
Nadia

Please login or Register to Submit Answer