Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
7 subscribers
Views
3816 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, What is the maximum number of records that can be persisted to a
sapnas
over 8 years ago
Hi,
What is the maximum number of records that can be persisted to a database ( in my case I am using MySQL) at a time (say a CDT has close to 1000 records) using "Write to Data Store Entity Smart Service" ?
OriginalPostID-163827
OriginalPostID-163827
Discussion posts and replies are publicly visible
0
Eduardo Fuentes
Appian Employee
over 8 years ago
More than the number of records it would be the size of the query itself. At the end they are both related but I wanted to clarify.
The limit is
dev.mysql.com/.../packet-too-large.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sapnas
over 8 years ago
Thanks Eduardo.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@sapnas So far from my experience I don't think there is any limit in Appian when we go with Integrations smart services to make updates in the database. To the best of my knowledge this should be specific to the database vendor we choose. For instance, in one particular scenario I wrote a cdt to database that has more than 100000 records. So far I remember there isn't any limit in Appian which controls the amount of data that should be inserted using Integrations smart services. But we need to keep in mind that the system's performance will be impacted to a huge extent as the number of records to update goes on increasing. So while doing these kind of operations, we need to consider prepare, execute, transform phase's(This has been elaborated in Health Check in documentation) metrics which will say how the operation is being carried out. Further this may flag your health check results as high risk if the amount of data is heavy.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@sapnas Also I would like to suggest to opt for batching technique if you think that the amount of data is very heavy. For instance, Appian has flagged a write operation as high risk which just writes 1000 records to a table that has 6 columns and no relationships in it.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sapnas
over 8 years ago
Thank You Sikhivahans for additional inputs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel