hi
I would like to ask a question.
What is the disadvantages of query database smart servie.Which point is better than record type?
Is there anything better than record type?
Thanks
Discussion posts and replies are publicly visible
The main thing to remember is that the the Query Database smart service uses SQL, while querying and writing data through records uses the structure of the data model you've already defined in your application, which should make it easier and faster.
Since Appian is a low-code platform, using records is our low-code method of interacting with your database and other systems. At this point I'd only recommend using the Query Database smart service if something isn't obviously supported through records (which is getting pretty rare at this point).
Can you give some more context to the question? Are you trying to make a decision on which one to use?
Peter Lewis
Thanks you for your response.
In our system's database structure there are many places where recordtype relationships are not possible.In our system, the usage rate of the query database smart service is expected to be approximately 70%.I'm worried about it's okay or not.I'm looking for a better way.
spykid said:In our system's database structure there are many places where recordtype relationships are not possible.
Why not? Can you provide more context?
spykid said:In our system, the usage rate of the query database smart service is expected to be approximately 70%.
Also can you give more context to this one? I'm not exactly sure what usage of 70% means - 70% of what?
If you mean that 70% of your queries would be using the QD Smart Service - that is too much IMO.
I only use QD in exceptional situations. Should definitely not be the norm.
IMHO using QD for 70% of your queries feels like something was going severely wrong in solution design.
Can you explain why that is?