Database Connection Faulting, Too Many Connections?

In addition to what @pturmel said, you should also try to eliminate as much traffic as possible. How many of these queries are returning filtered data of the original queried dataset? If possible instead of query bindings which return a subset of the original dataset, opt instead for an expression binding or property binding with transform to generate the filtered subset. This eliminates the extra trips to the DB and lessens the load.

Also, if you have/or can use Phil's Integration Toolkit Module there are tools included that can make this type of task (filtering data) easier.

1 Like