MESSAGE
| DATE | 2020-12-21 |
| FROM | Mithun Bhattacharya
|
| SUBJECT | Re: [Hangout - NYLXS] suggestions for perl as web development
|
From hangout-bounces-at-nylxs.com Tue Dec 22 15:34:02 2020
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: from www2.mrbrklyn.com (www2.mrbrklyn.com [96.57.23.82])
by mrbrklyn.com (Postfix) with ESMTP id 5471F16401D;
Tue, 22 Dec 2020 15:34:01 -0500 (EST)
X-Original-To: hangout-at-www2.mrbrklyn.com
Delivered-To: hangout-at-www2.mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 1000)
id D98D4163F60; Tue, 22 Dec 2020 15:32:27 -0500 (EST)
Resent-From: Ruben Safir
Resent-Date: Tue, 22 Dec 2020 15:32:27 -0500
Resent-Message-ID: <20201222203227.GN17865-at-www2.mrbrklyn.com>
Resent-To: hangout-at-mrbrklyn.com
X-Original-To: ruben-at-mrbrklyn.com
Delivered-To: ruben-at-mrbrklyn.com
Received: from mxout1-ec2-va.apache.org (mxout1-ec2-va.apache.org
[3.227.148.255]) by mrbrklyn.com (Postfix) with ESMTP id 968E6163FB0
for ; Mon, 21 Dec 2020 03:06:42 -0500 (EST)
Received: from mail.apache.org (mailroute1-lw-us.apache.org [207.244.88.153])
by mxout1-ec2-va.apache.org (ASF Mail Server at
mxout1-ec2-va.apache.org) with SMTP id AAE034544D
for ; Mon, 21 Dec 2020 08:06:41 +0000 (UTC)
Received: (qmail 56292 invoked by uid 500); 21 Dec 2020 08:06:41 -0000
Mailing-List: contact modperl-help-at-perl.apache.org; run by ezmlm
Precedence: bulk
Delivered-To: mailing list modperl-at-perl.apache.org
Received: (qmail 56271 invoked by uid 99); 21 Dec 2020 08:06:40 -0000
Received: from spamproc1-he-fi.apache.org (HELO spamproc1-he-fi.apache.org)
(95.217.134.168)
by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Dec 2020 08:06:40 +0000
Received: from localhost (localhost [127.0.0.1])
by spamproc1-he-fi.apache.org (ASF Mail Server at spamproc1-he-fi.apache.org)
with ESMTP id 29957C02DD
for ; Mon, 21 Dec 2020 08:06:40 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamproc1-he-fi.apache.org
X-Spam-Flag: NO
X-Spam-Score: 0
X-Spam-Level:
X-Spam-Status: No, score=0 tagged_above=-999 required=6.31
tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1,
DKIM_VALID_EF=-0.1, HTML_MESSAGE=0.2, SPF_PASS=-0.001,
URIBL_BLOCKED=0.001] autolearn=disabled
Authentication-Results: spamproc1-he-fi.apache.org (amavisd-new);
dkim=pass (2048-bit key) header.d=gmail.com
Received: from mx1-he-de.apache.org ([116.203.227.195])
by localhost (spamproc1-he-fi.apache.org [95.217.134.168]) (amavisd-new,
port 10024) with ESMTP id tnnEzs6KQksw for ;
Mon, 21 Dec 2020 08:06:39 +0000 (UTC)
Received-SPF: Pass (mailfrom) identity=mailfrom;
client-ip=2607:f8b0:4864:20::931; helo=mail-ua1-x931.google.com;
envelope-from=mithnb-at-gmail.com; receiver=
Received: from mail-ua1-x931.google.com (mail-ua1-x931.google.com
[IPv6:2607:f8b0:4864:20::931])
by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS
id 21DAE7FBA7
for ; Mon, 21 Dec 2020 08:06:39 +0000 (UTC)
Received: by mail-ua1-x931.google.com with SMTP id f29so3064273uab.0
for ; Mon, 21 Dec 2020 00:06:38 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025;
h=mime-version:references:in-reply-to:from:date:message-id:subject:to;
bh=rU5mf/TJeDnSqyu6pRKsaAlLx07rTR8At+e90VgBTn8=;
b=TZl8Akk4FAa/SURGUtd6c28CgoBA+H5Su3f39nQuBPwWCJDBqjI/LnlZPp6IDMQjf8
Fn6fsvkEQBlilAWYw9vXbDiad/diz3pw9+j2+bODz282uPZpP1xjpr0zE7TURmtCHto7
OnGaZJ9GqWu/LiOPyq9uwfYvz/Xgo6bv6qvxeuo42z9bcIla2cLlQ7znLPNFZX30vPiu
Ztxyrxj2fYSWGHcl1g0D1KNXguyWsAb/Y7g1URPhZag6Jm5t+aL6nIFzjf8r9xgs9AEH
ucWRxTpvi5cGeEJ+/w2tJhCH/3/odjmlTMXiSzD7YfNUhxnbj+uxDjX7Xgyee7l1Y/gJ
bUdw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20161025;
h=x-gm-message-state:mime-version:references:in-reply-to:from:date
:message-id:subject:to;
bh=rU5mf/TJeDnSqyu6pRKsaAlLx07rTR8At+e90VgBTn8=;
b=kob8lQv7h5JEknpegVYdNcQymB10kPSrt7JNYx2XRbhZY+gNdGXj8u8fhKSg/92lhM
xkd0hChdWlwMqQdV0cK47YnZnYhWFu3lCdphxzILNjespQ2YjC5VSwMPKhn+LkibHE9M
hXN8nLOgMc/7OSwYilatUyU7D7dcOkE0A1189ympED6HRYSNtSpwCJCkfmY9yzsznNOr
ngN51jbOjBvcfDfNeTyOy+JtCmyy6xQ706NY/sNVBTow9FNBNaINXlb/z+r0a5JsZ5b2
9UqXObt1G3bGMShG3Xg47Qfs+sxiij103K6JQmbpCyGMS6MMT3DQ4D1ggWuhWwZCcka0
jsAA==
X-Gm-Message-State: AOAM531rIdmQeiJZRRvFqrvnVz/WOBvlt3FZuPw/0u6qs16MQn4Yw2X/
wuaqimDx4KKoAQgN/IVydt/9csakSAfzs4x7mGBhhrrb
X-Google-Smtp-Source: ABdhPJzaJqCIo9WSnBUOWIoOoHaIwlRiOrKgdZARIcfqhHKtwNcsVDG5AUwrXGsC5OYHb0WqLsirM1nA1yOTkfz6VbM=
X-Received: by 2002:ab0:6703:: with SMTP id q3mr11261646uam.93.1608537992257;
Mon, 21 Dec 2020 00:06:32 -0800 (PST)
MIME-Version: 1.0
References:
<27779c3e56564c73a7fa49b49cc3f9f0-at-sanger.ac.uk>
<20201221050824.c1f73f5de5d2d3431da6a7e5-at-wanadoo.fr>
<20201221082642.026e4cabffa471f68fd7a53a-at-wanadoo.fr>
In-Reply-To: <20201221082642.026e4cabffa471f68fd7a53a-at-wanadoo.fr>
From: Mithun Bhattacharya
Date: Mon, 21 Dec 2020 02:06:21 -0600
Message-ID:
To: mod_perl list
Subject: Re: [Hangout - NYLXS] suggestions for perl as web development
language [EXT]
X-BeenThere: hangout-at-nylxs.com
X-Mailman-Version: 2.1.30rc1
List-Id: NYLXS Tech Talk and Politics
List-Unsubscribe: ,
List-Archive:
List-Post:
List-Help:
List-Subscribe: ,
Content-Type: multipart/mixed; boundary="===============1824573739=="
Errors-To: hangout-bounces-at-nylxs.com
Sender: "Hangout"
--===============1824573739==
Content-Type: multipart/alternative; boundary="000000000000a2e41205b6f4ef5e"
--000000000000a2e41205b6f4ef5e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Making a wild guess here - most RDBMS won't like it if you make thousands
of queries per second across 500 tables every second. Can this be done -
yes but most setup's aren't tuned to be able to handle such a scenario.
If I was doing something like this I can imagine quite a few places which
would fall apart in my current code which would have nothing to do with
either mod_perl or forking/threading. Again I have absolutely no idea what
has been implemented by John so it is quite possible it is a mod_perl and
forking issue but that can not be generalized for everyone.
On Mon, Dec 21, 2020 at 1:27 AM Vincent Veyron wrote:
>
> [You forgot to cc the list ]
>
> On Sun, 20 Dec 2020 23:16:03 -0500
> John Dunlap wrote:
>
> > We run 20 customers on a single box and our database has approximately
> 500
> > tables. We run hundreds or thousands of queries per second.
> >
>
> 500 tables is a lot more than what I typically handle. I'm sure it
> complicates things.
>
> But see this post by James Smith in a recent thread :
>
>
> http://mail-archives.apache.org/mod_mbox/perl-modperl/202008.mbox/ajax/%3=
Cef383804cf394c53b48258531891d12b%40sanger.ac.uk%3E
>
> Easier to read in this archive :
>
> http://mail-archives.apache.org/mod_mbox/perl-modperl/202008.mbox/browser
>
> I also remember a post by a chinese guy who handled the same order of
> database size, in which he wrote that he had compared several frameworks
> and mod_perl was the fastest; but that was something like 10 years ago, a=
nd
> I can't find it anymore.
>
> So I'm not sure how mod_perl could handle that kind of load and be
> horribly inefficient?
>
> (I forgot to say in my previous post that over 50% of the time used by my
> script is spent on the _one_ query out of 120 that writes a smallish
> session hash to disk)
>
> --
> Bien =C3=A0 vous, Vincent Veyron
>
> https://compta.libremen.com
> Logiciel libre de comptabilit=C3=A9 g=C3=A9n=C3=A9rale en partie double
>
--000000000000a2e41205b6f4ef5e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Making a wild guess here - most RDBMS won't like it if= you make thousands of queries=C2=A0per second across 500 tables every seco= nd. Can this be done - yes but most setup's aren't tuned to be able= to handle such a scenario.
If I was doing something lik=
e this I can imagine quite a few places which would fall apart in my curren=
t code which would have nothing to do with either mod_perl or forking/threa=
ding. Again I have absolutely no idea what has been implemented by John so =
it is quite possible it is a mod_perl and forking issue but that can not be=
generalized for everyone.
--000000000000a2e41205b6f4ef5e--
--===============1824573739==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Hangout mailing list
Hangout-at-nylxs.com
http://lists.mrbrklyn.com/mailman/listinfo/hangout
--===============1824573739==--
--===============1824573739==
Content-Type: multipart/alternative; boundary="000000000000a2e41205b6f4ef5e"
--000000000000a2e41205b6f4ef5e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Making a wild guess here - most RDBMS won't like it if you make thousands
of queries per second across 500 tables every second. Can this be done -
yes but most setup's aren't tuned to be able to handle such a scenario.
If I was doing something like this I can imagine quite a few places which
would fall apart in my current code which would have nothing to do with
either mod_perl or forking/threading. Again I have absolutely no idea what
has been implemented by John so it is quite possible it is a mod_perl and
forking issue but that can not be generalized for everyone.
On Mon, Dec 21, 2020 at 1:27 AM Vincent Veyron wrote:
>
> [You forgot to cc the list ]
>
> On Sun, 20 Dec 2020 23:16:03 -0500
> John Dunlap wrote:
>
> > We run 20 customers on a single box and our database has approximately
> 500
> > tables. We run hundreds or thousands of queries per second.
> >
>
> 500 tables is a lot more than what I typically handle. I'm sure it
> complicates things.
>
> But see this post by James Smith in a recent thread :
>
>
> http://mail-archives.apache.org/mod_mbox/perl-modperl/202008.mbox/ajax/%3=
Cef383804cf394c53b48258531891d12b%40sanger.ac.uk%3E
>
> Easier to read in this archive :
>
> http://mail-archives.apache.org/mod_mbox/perl-modperl/202008.mbox/browser
>
> I also remember a post by a chinese guy who handled the same order of
> database size, in which he wrote that he had compared several frameworks
> and mod_perl was the fastest; but that was something like 10 years ago, a=
nd
> I can't find it anymore.
>
> So I'm not sure how mod_perl could handle that kind of load and be
> horribly inefficient?
>
> (I forgot to say in my previous post that over 50% of the time used by my
> script is spent on the _one_ query out of 120 that writes a smallish
> session hash to disk)
>
> --
> Bien =C3=A0 vous, Vincent Veyron
>
> https://compta.libremen.com
> Logiciel libre de comptabilit=C3=A9 g=C3=A9n=C3=A9rale en partie double
>
--000000000000a2e41205b6f4ef5e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Making a wild guess here - most RDBMS won't like it if= you make thousands of queries=C2=A0per second across 500 tables every seco= nd. Can this be done - yes but most setup's aren't tuned to be able= to handle such a scenario.
If I was doing something lik=
e this I can imagine quite a few places which would fall apart in my curren=
t code which would have nothing to do with either mod_perl or forking/threa=
ding. Again I have absolutely no idea what has been implemented by John so =
it is quite possible it is a mod_perl and forking issue but that can not be=
generalized for everyone.
--000000000000a2e41205b6f4ef5e--
--===============1824573739==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Hangout mailing list
Hangout-at-nylxs.com
http://lists.mrbrklyn.com/mailman/listinfo/hangout
--===============1824573739==--
|
|
