How many DB query's do you have in an action file?

Hi All,

Just wanted to get people’s thoughts on how many DB query’s or steps you might have in a single server connect ‘action file’ before you start adding new files?

Naturally i try to create a logical grouping, and i’m aware that the steps run in order one after the other and if one fails they all fail. So just thought if ask if anyone wanted to share their thoughts on how they structure their action files and steps involved.

For instance, is there a performance difference on loading 2 x server connect queryies in app connect each with 1 x DB connection and 1 X DB query VS loading 1 x server connect file in app connect with 2 x queries in it?

Thoughts?

Cheers,
Phil