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??

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