[pmg-devel] New filter

[Sofiane BENMEKKI]

Indeed, it could generate some latence on mail delivery due to the SQL requests.
I tested it on server that handles about 10 000 a day and there no serious impact.

To avoid performance implications it will be better to have a dedicated table updated at same time that statistics and that will reduce query time.
For now it's not, because my restriction was to not change a lot of PMG core code/structure.

I understand you no-go, the Quota filter will be soon available on my Github as patch that could be applied on PMG for whose want to accept the performance implications.

----- Mail original -----
De: "Dietmar Maurer" <dietmar at proxmox.com>
À: "Davide Bozzelli" <davide.bozzelli at gci.it>, "Sofiane BENMEKKI" <sofiane.benmekki at m2ssi.fr>, "pmg-devel" <pmg-devel at pve.proxmox.com>
Envoyé: Samedi 15 Juin 2019 07:37:41
Objet: Re: [pmg-devel] New filter

> On 11 June 2019 at 07:59 Davide Bozzelli <davide.bozzelli at gci.it> wrote:
> 
> 
> I disagree
> 
> Sometimes we would like to enforce different quota for different user or 
> domain.
> 
> This patch could be useful
> 

Maybe, but this patch has serious performance implications. Seems there is one 
big slow database query for each email address, so that is a no-go. Someone already
done benchmarks with this patch applied?

_______________________________________________
pmg-devel mailing list
pmg-devel at pve.proxmox.com
https://pve.proxmox.com/cgi-bin/mailman/listinfo/pmg-devel