Skip to Content (Press Enter)
2018-03-08 20-43-12
Robert Chanphakeo
1Views
4Comments
Integration studio:  maximum number of imported database tables?
Question
  1. Are there any limitations to how many database tables you could import via Integration studio import feature?
  2. Has it been tested? if so how many times has been imported and used in an extension? 
  3. What is the recommended number of tables? 100 tables, 1000 tables? 



0
0
18 Sep 2015
Copy Link
2018-03-08 20-43-12
Robert Chanphakeo
The reason I ask about the maximum number of database tables I could import is because integration studio (sometimes) crashes on me and this is when I import ~200 tables (MySQL database). 

It takes approximately 20 seconds to import ~200 tables via local MySQL database server! (therefore it takes ~100 milliseconds per table!)



0
0
20 Sep 2015
Copy Link
2016-04-21 20-09-55
J.
 
MVP
the import wizard is very very inefficient.

Normally I try to import table via a user/schema with not a small amount of tables.
and do it a couple of times.

0
0
20 Sep 2015
Copy Link
2018-03-08 20-43-12
Robert Chanphakeo
J

What database did you import from and how many tables in total?
0
0
20 Sep 2015
Copy Link
2016-04-21 20-09-55
J.
 
MVP
Oracle (since that's the one that is able to do it)

I have no clue why Outsystems decide to retrieve all metadata even before you are selecting the tables...
(if that is the case)
All I know there will be a chance a timeout.
0
0
21 Sep 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.