Data server API for create index

posted on November 2nd, 2022

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 ⋅ 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:

If the users have small datasets, we suggest writing a server-side script that returns the necessary data in a JSON or CSV format. You can find the details in our documentation: https://www.flexmonster.com/doc/connecting-to-other-data-sources/#server-side-script
You can implement the Flexmonster custom data source API used in Flexmonster Data Server. With this approach, you will have complete control over data processing. You can add any additional data processing in your server-side implementation, for instance, creating indexes dynamically. You are welcome to check our documentation for reference: https://www.flexmonster.com/doc/introduction-to-custom-data-source-api/

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

Kind regards,
Nadia

Public

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

Data server API for create index

2 answers

Please login or Register to Submit Answer