Path: ...!news.mixmin.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Lawrence D'Oliveiro <ldo@nz.invalid>
Newsgroups: comp.os.vms
Subject: Re: Apache + mod_php performance
Date: Sat, 28 Sep 2024 05:09:18 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 10
Message-ID: <vd831t$14gsa$3@dont-email.me>
References: <vcv0bl$39mnj$1@dont-email.me> <vd1bdp$3npm3$1@dont-email.me>
	<vd1lgd$dbq$1@reader1.panix.com> <vd1u8j$3qqpg$1@dont-email.me>
	<vd3vhj$849$1@reader1.panix.com> <vd6l5h$pmt5$1@dont-email.me>
	<vd7ec3$tdq8$4@dont-email.me> <vd7fdf$tgu3$1@dont-email.me>
	<vd7glq$tdq8$16@dont-email.me> <vd7hme$tgu3$3@dont-email.me>
	<vd7nk3$12csp$1@dont-email.me> <66f762e1$0$711$14726298@news.sunsite.dk>
	<vd7o2j$12e29$2@dont-email.me> <vd7onl$tvpn$1@dont-email.me>
	<vd7p3q$12jse$1@dont-email.me> <66f76d03$0$711$14726298@news.sunsite.dk>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 28 Sep 2024 07:09:18 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="2132f4845d2292b1a04f05d8b30f9975";
	logging-data="1196938"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1/Mj0ItQikx7naxilIGTd4p"
User-Agent: Pan/0.160 (Toresk; )
Cancel-Lock: sha1:9e0Oeb4sz0jj/VEaJ9VEKIGdl/A=
Bytes: 1850

On Fri, 27 Sep 2024 22:42:10 -0400, Arne Vajhøj wrote:

> If you need to get/update a row by primary key then sharding works
> perfect - you go to the right server and just do it.
> 
> If you need to get/update a number of rows and you don't know which
> servers they are on, then it means querying all servers, which both
> create performance and consistency problems.

Well, you were the one who brought up sharding, not me ...