|FROM ||James Smith
|SUBJECT ||Re: [Hangout - NYLXS] suggestions for perl as web development
|> (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)
The first rule of session hashes is don't use session hashes, but the 2nd rule of session hashes is don't write them to disk - that is really inefficient. Look at using something like MySQL, memcached, redis, ... to store them instead - whatever you do - just avoid writing to disk!
From: Vincent Veyron
Sent: 21 December 2020 07:27
To: John Dunlap
Subject: Re: suggestions for perl as web development language [EXT]
[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 :
Easier to read in this archive :
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, and I can't find it anymore.
So I'm not sure how mod_perl could handle that kind of load and be horribly inefficient?
Bien à vous, Vincent Veyron
Logiciel libre de comptabilité générale en partie double
The Wellcome Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.
Hangout mailing list