Search Postgresql Archives
can stored procedures with computational sql queries improve API performance?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: can stored procedures with computational sql queries improve API performance?
- From: Krishnakant Mane <kkproghub@xxxxxxxxx>
- Date: Wed, 10 Jul 2024 06:28:46 +0530
- User-agent: Betterbird (Linux)
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.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]