Thanks Paolo,
I'll see how i can enhance this setup.
Kind regards,
Luc
On Fri, Mar 3, 2017 at 8:23 AM, Paolo Lucente wrote:
>
> Hi Luc,
>
> At a glance it looks a case where you are overwhelming the RDBMS 1) you
> write data to a static table, ie. acct, likely making the table and its
> index
Hi Luc,
At a glance it looks a case where you are overwhelming the RDBMS 1) you
write data to a static table, ie. acct, likely making the table and its
index(es) big; 2) you make use of UPDATE queries, which are expensive;
whereas you should try to aim at an INSERT-only environment (*); 3) the
ag