Skip to main content
M
marcom0706
May 10, 2024
Question

Load Csv File to Database

  • May 10, 2024
  • 2 replies
  • 0 views

Hi, I wanted to ask what is the maximum number of records that can be loaded into the DB using the Load Csv File to Database plug-in?

2 replies

karumurua531442
karumurua531442
May 11, 2024

hi [mention:ff6be4d49be6484ab2107e75ba39c0d9:e9ed411860ed4f2ba0265705b8793d05] AFAIK, Appian doesn't have a hard limit on the number of records that can be loaded, but practical limitations might apply based on the database and infrastructure. For large datasets, I would recommend conducting performance testing to have an optimal batch size and to ensure that the process can handle the expected load efficiently without causing performance issues.

M
marcom0706Author
May 11, 2024

Hi [mention:3510a5189ce1477eaf2e09f5858c87e9:e9ed411860ed4f2ba0265705b8793d05] thank you for your reply. In this video https://www.youtube.com/watch?v=TV35-cjm100 and in the last comment it is specified that up to 6 million records can be uploaded.

My worst case is the loading of 600/700 thousand records. Should I manipulate the CSV in some way or is the smart service sufficient? What do you think? Another tips, my DB is Maria DB.

Terms & ConditionsAccessibility statement