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
7 replies
Subscribers
5 subscribers
Views
2831 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
Hi all, We have a requirement of writing a multiple Nested Cdt's and Webserv
RAMASESHU RAVEPATI
A Score Level 1
over 8 years ago
Hi all, We have a requirement of writing a multiple Nested Cdt's and Webservice Records into different tables in MySQL Database. I successfully started to push couple of CDT's with multiWrite DataStore smart service. I want push all Values at one time. Is there any best practice to be followed while doing this? I read, keep the data <1MB as one of the best practice. Is there anyway to measure data transfer??
OriginalPostID-177072
OriginalPostID-177072
Discussion posts and replies are publicly visible
0
danny.leo
Certified Associate Developer
over 8 years ago
Hi Ramasehur... Multiple nested CDTs and nesting CDTs is NOT an Appian best practice - I would avoid nesting and keep a flatter structure when possible.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chrism967
over 8 years ago
However a flatter structure is often not good database design... When correct normalisation is required due to integrations or whatever, we have sometimes reverted to calling stored procs passing in parameter values which again isn't something that's always recommended but sometimes needs must. :-/
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
danny.leo
Certified Associate Developer
over 8 years ago
Hi Chrism... Yeah, I get it. I always proceed with caution if I intentionally break an Appian Best Practice.... but I understand... I would def document this and also do some extra performance testing for end-user experience!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
RAMASESHU RAVEPATI
A Score Level 1
over 8 years ago
Thank Danny and Chrism,
chrism, We were using Stored Procs in my old project. In this project we cannot pull that kind of resource now. Currently, we have been using multiple External Databases and web service calls for Data Flow until now.Trying to build a Data Store from scratch and i want to follow Best Practices.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
RAMASESHU RAVEPATI
A Score Level 1
over 8 years ago
Is there a way to measure the Data transfer ??
Our application has lot of Web CDT's and multiple nested CDT's to push into our Data Store.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
danny.leo
Certified Associate Developer
over 8 years ago
forum.appian.com/.../Database_Performance_Best_Practices.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
RAMASESHU RAVEPATI
A Score Level 1
over 8 years ago
Thank you Danny.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel