public inbox for [email protected]  

help / color / mirror / Atom feed

From: Krishnakant Mane <[email protected]>
To: [email protected]
Subject: can stored procedures with computational sql queries improve API performance?
Date: Wed, 10 Jul 2024 06:28:46 +0530
Message-ID: <[email protected]> (raw)

Hello.

I have a straight forward question, but I am just trying to analyze the 
specifics.

So I have a set of queries depending on each other in a sequence to 
compute some results for generating financial report.

It involves summing up some amounts from tuns or of rows and also on 
certain conditions it categorizes the amounts into types (aka Debit 
Balance, Credit balance etc).

There are at least 6 queries in this sequence and apart from 4 input 
parameters. these queries never change.

So will I get any performance benefit by having them in a stored 
procedure rather than sending the queries from my Python based API?

Regards.

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: can stored procedures with computational sql queries improve API performance?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox