Query Database Smart Service: Hi All, I was using that query DB

rishub356 over 8 years ago

Query Database Smart Service:

Hi All,
I was using that query DB & it returns at max 10 rows only. I need to use the query DB node in my process model & I wanted to fetch may be 200 or 300 records at a time. I can't use batches of 10 & was wondering if there is something we can do to get more records in Query DB node?

Thanks

Discussion posts and replies are publicly visible

0 ChristineH
Certified Lead Developer
over 8 years ago

This is the default setting for the query DB node:
forum.appian.com/.../Query_Database_Smart_Service.html.
You can change the property (forum.appian.com/.../Configuring_Relational_Databases.html) with care! Keep in mind, the more data you return in a process the larger your footprint is and the more memory you consume!

Can you use a query rule instead?

Hope that helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sagarl511
A Score Level 2
over 8 years ago

Another option is to use execute stored procedure smart service. But I recommend using OOTB feature of query entity to fetch records from db.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sachin Pandey
A Score Level 1
over 8 years ago

Can you use query rule instead? its easier to manage the data subset.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 matthewb85
A Score Level 3
over 8 years ago

Have you found a limitation that causes a!queryEntity not to function properly? You can call that in a script task and get much more control over you results than with a query DB node or even a query rule.
forum.appian.com/.../System_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rajivr
Certified Associate Developer
over 8 years ago

That's why best practices suggests to use other means of fetching data versus going for query to db smart service(which has other disadvantages too including memory). Use query entity instead which would be best option.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sparshs over 8 years ago

why cannot you use query entity instead?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel