Path: nntp.eternal-september.org!news.eternal-september.org!eternal-september.org!.POSTED!not-for-mail
From: Lawrence D'Oliveiro <ldo@nz.invalid>
Newsgroups: comp.os.linux.misc
Subject: Re: Program to dole out jpg's to subdirctories, card-dealing  style.
Date: Mon, 30 Jun 2025 06:55:20 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 11
Message-ID: <103tccn$21i99$5@dont-email.me>
References: <103a6c8@dont-email.me> <38h7jlxaom.ln2@Telcontar.valinor>
	<eli506291631@qaz.wtf>
	<43944360cb7c4b15fb52908272e9ab34@msgid.frell.theremailer.net>
	<eli$2506300151@qaz.wtf>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Mon, 30 Jun 2025 08:55:20 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="e7340121927b55508c76d666a3d900cd";
	logging-data="2148649"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+t4fHRqOUejdYHRk4l7zA2"
User-Agent: Pan/0.162 (Pokrosvk)
Cancel-Lock: sha1:DjzybwQVj8b4AM24KufSqEaG21E=

On Mon, 30 Jun 2025 05:53:34 -0000 (UTC), Eli the Bearded wrote:

> My program uses mysql. But (a) I'm not great at writing sql and (b) one
> of the largest pain points is loading data into it.

That example query looked reasonable to me. If you find things running 
slow, there are ways to find out where the bottlenecks are -- these are 
usually fixed by adding indexes to suitable fields.

Loading data can be slow. Doing it fast can depend on the DBMS. For 
SQLite, doing all the INSERTs in a transaction helps enormously.