Observation on query sent to Oracle by Appian servers

frankq over 8 years ago

We observed that DB query sent to oracle were without SQL where clause. Since our application queries tables/views with millions of records. Does it mean Appian retrieves all those millions of records then process them?

Discussion posts and replies are publicly visible

0 shaun.noonan1 over 8 years ago

Frank, could you provide more details about the query? Appian queries certainly have the ability to be filtered. It would depend on your usage of the functions that make the query.

If you suspect this could be a product issue, then I would encourage you to log a support case and they can help you more directly.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Shyam Bommakanti
Certified Lead Developer
over 8 years ago

@frankq refer to query limits docs.appian.com/.../Post-Install_Configurations.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel