Good Morning guys !
I have a project where I pull several data from a DBConnector that supplies several globaltables, but in some of them the data ends up not being loaded, how do I make this loading lighter. I think that might be the problem.
Limit of data to be pulled from a database
FlexSim 21.2.4
Why don't you load all of these into the same table and add a column indicating to which resource each record is related? If it's large make the table a bundle data type.
Also - what makes you think the import is failing due to volume? Have you testing the query outside of FlexSim?
I tested this same query outside and it worked, so I think it has a problem related to the volume. In your first point, how do I make a packet data, I didn't understand that very well.
You can change a table to bundle type in the Properties panel (usually on the right side).
Hi @kauan pedroso, was Yasmin's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.
Hello, Kauan!
Please let us know if your answer was replied!
If this query already worked on other import, I believe your problem is in your database. I higlhy recommend you to read the documentation about Database Connector (https://docs.flexsim.com/en/22.2/Reference/Tools/DatabaseConnectors/DatabaseConnectors.html#page-header).
Looking there I saw that some database requires you to enter the full database connection string (picture below)
Hope it can help!
16 People are following this question.
