question

kauan pedroso avatar image
0 Likes"
kauan pedroso asked Jeanette F commented

Limit of data to be pulled from a database

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.

1681743111563.png

1681743132778.png

busca-de-dados-3-autosave-jl3_autosave.fsm

FlexSim 21.2.4
global tabledatabasesql server
· 4
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦ commented ·

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?

0 Likes 0 ·
kauan pedroso avatar image kauan pedroso Jason Lightfoot ♦ commented ·

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.

0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦ kauan pedroso commented ·
You can change a table to bundle type in the Properties panel (usually on the right side).
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

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.

0 Likes 0 ·

1 Answer

Yasmin avatar image
1 Like"
Yasmin answered Yasmin edited

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)

1681995744727.png

Hope it can help!


1681995744727.png (22.6 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.