From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from ffbox0-bg.mplayerhq.hu (ffbox0-bg.ffmpeg.org [79.124.17.100]) by master.gitmailbox.com (Postfix) with ESMTP id 960814018F for ; Sun, 5 Mar 2023 13:35:26 +0000 (UTC) Received: from [127.0.1.1] (localhost [127.0.0.1]) by ffbox0-bg.mplayerhq.hu (Postfix) with ESMTP id 455F468A120; Sun, 5 Mar 2023 15:35:19 +0200 (EET) Received: from relay1-d.mail.gandi.net (relay1-d.mail.gandi.net [217.70.183.193]) by ffbox0-bg.mplayerhq.hu (Postfix) with ESMTPS id 0FC9568ACC1 for ; Sun, 5 Mar 2023 15:35:12 +0200 (EET) Received: (Authenticated sender: michael@niedermayer.cc) by mail.gandi.net (Postfix) with ESMTPSA id A2885240004; Sun, 5 Mar 2023 13:35:11 +0000 (UTC) Date: Sun, 5 Mar 2023 14:35:08 +0100 From: Michael Niedermayer To: FFmpeg development discussions and patches Message-ID: <20230305133508.GB1928637@pb2> MIME-Version: 1.0 Subject: [FFmpeg-devel] trac optimization X-BeenThere: ffmpeg-devel@ffmpeg.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: FFmpeg development discussions and patches List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-To: FFmpeg development discussions and patches Cc: mplayer-dev-eng@mplayerhq.hu Content-Type: multipart/mixed; boundary="===============3412651627200450685==" Errors-To: ffmpeg-devel-bounces@ffmpeg.org Sender: "ffmpeg-devel" Archived-At: List-Archive: List-Post: --===============3412651627200450685== Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="s/l3CgOIzMHHjg/5" Content-Disposition: inline --s/l3CgOIzMHHjg/5 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi due to continuing performance issues (and complaints) about trac speed ive switched the database to WAL mode. This should make th db signifciantly faster but iam not sure the database was the limiting factor. Now reading and writing can proceed concurrently, before writes would block everything. One might think "but there wasnt that much changed/writen" this is logic but not true. The database stores every recent spammer access and everything th= at could be a spammer, every session cookie (we have 129379 temporary sessions= in teh ffmpeg trac databse for example). This is bad design arguably of course= .... If you notice any new issue, please report it here. Ive made a backup from trac before this and we have daily trac backups if this causes a major issue i intend to rollback to a previous backup and disable it again. But i expect no major issue, its likely either faster or = not. thx --=20 Michael GnuPG fingerprint: 9FF2128B147EF6730BADF133611EC787040B0FAB Old school: Use the lowest level language in which you can solve the problem conveniently. New school: Use the highest level language in which the latest supercomputer can solve the problem without the user falling asleep waiting. --s/l3CgOIzMHHjg/5 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iF0EABEIAB0WIQSf8hKLFH72cwut8TNhHseHBAsPqwUCZASahgAKCRBhHseHBAsP q7bbAJ0SoUOTnx/3H5DyiYsbL2Sn6zvZ+wCeL84ZSHIB8lApgEbtkNC1X8EU2wM= =b3NM -----END PGP SIGNATURE----- --s/l3CgOIzMHHjg/5-- --===============3412651627200450685== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ ffmpeg-devel mailing list ffmpeg-devel@ffmpeg.org https://ffmpeg.org/mailman/listinfo/ffmpeg-devel To unsubscribe, visit link above, or email ffmpeg-devel-request@ffmpeg.org with subject "unsubscribe". --===============3412651627200450685==--