Sujet : Re: Program to dole out jpg's to subdirctories, card-dealing style.
De : ldo (at) *nospam* nz.invalid (Lawrence D'Oliveiro)
Groupes : comp.os.linux.miscDate : 30. Jun 2025, 07:55:20
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <103tccn$21i99$5@dont-email.me>
References : 1 2 3 4 5
User-Agent : Pan/0.162 (Pokrosvk)
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.
| Date | Sujet | # | | Auteur |
| 23 Jun 25 |  Program to dole out jpg's to subdirctories, card-dealing style. | 78 | | pH |
| 23 Jun 25 |  Re: Program to dole out jpg's to subdirctories, card-dealing style. | 6 | | Robert Heller |
| 23 Jun 25 |   Re: Program to dole out jpg's to subdirctories, card-dealing style. | 5 | | pH |
| 23 Jun 25 |  Re: Program to dole out jpg's to subdirctories, card-dealing style. | 2 | | Robert Heller |
| 23 Jun 25 |  Re: Program to dole out jpg's to subdirectories, card-dealing style. | 1 | | Lawrence D'Oliveiro |
| 23 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | rbowman |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | pH |
| 23 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 2 | | Lawrence D'Oliveiro |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | pH |
| 23 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 5 | | Eli the Bearded |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 4 | | pH |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 3 | | Rich |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 2 | | Eli the Bearded |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | Lawrence D'Oliveiro |
| 23 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | c186282 |
| 23 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 62 | | Richard Kettlewell |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 52 | | pH |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 51 | | Lawrence D'Oliveiro |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 4 | | c186282 |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 3 | | rbowman |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 2 | | c186282 |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | rbowman |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 46 | | c186282 |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 45 | | Rich |
| 24 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 2 | | rbowman |
| 27 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | Rich |
| 25 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 42 | | c186282 |
| 27 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 41 | | Rich |
| 27 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 40 | | c186282 |
| 29 Jun00:06 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 39 | | Lawrence D'Oliveiro |
| 29 Jun04:41 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 38 | | Eli the Bearded |
| 29 Jun05:44 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | Lawrence D'Oliveiro |
| 29 Jun10:35 | XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 32 | | Nuno Silva |
| 30 Jun00:58 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 31 | | Lawrence D'Oliveiro |
| 30 Jun06:18 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 26 | | Eli the Bearded |
| 30 Jun07:52 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 25 | | Lawrence D'Oliveiro |
| 30 Jun19:50 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 19 | | Eli the Bearded |
| 30 Jun21:15 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 11 | | John Ames |
| 1 Jul01:30 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 1 | | Lawrence D'Oliveiro |
| 1 Jul08:38 | Re: XDG and Freedesktop | 9 | | Richard Kettlewell |
| 1 Jul20:49 | Re: XDG and Freedesktop | 8 | | John Ames |
| 2 Jul00:57 | Re: XDG and Freedesktop | 6 | | Lawrence D'Oliveiro |
| 2 Jul09:33 | Re: XDG and Freedesktop | 5 | | Nuno Silva |
| 3 Jul00:41 | Re: XDG and Freedesktop | 4 | | Lawrence D'Oliveiro |
| 3 Jul15:55 | Re: XDG and Freedesktop | 3 | | John Ames |
| 3 Jul16:37 | Re: XDG and Freedesktop | 2 | | The Natural Philosopher |
| 3 Jul16:53 | Re: XDG and Freedesktop | 1 | | John Ames |
| 2 Jul09:27 | Re: XDG and Freedesktop | 1 | | The Natural Philosopher |
| 1 Jul00:14 | Re: XDG and Freedesktop | 1 | | Bobbie Sellers |
| 1 Jul01:29 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 6 | | Lawrence D'Oliveiro |
| 1 Jul04:40 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 5 | | Eli the Bearded |
| 1 Jul05:28 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 4 | | Lawrence D'Oliveiro |
| 1 Jul17:01 | Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) | 3 | | John Ames |
| 1 Jul17:10 | Re: XDG and Freedesktop | 1 | | Bobbie Sellers |
| 2 Jul00:57 | Re: XDG and Freedesktop | 1 | | Lawrence D'Oliveiro |
| 1 Jul00:07 | Re: XDG and Freedesktop | 5 | | Nuno Silva |
| 1 Jul01:33 | Re: XDG and Freedesktop | 4 | | Lawrence D'Oliveiro |
| 1 Jul07:02 | Re: XDG and Freedesktop | 3 | | Nuno Silva |
| 1 Jul08:30 | Re: XDG and Freedesktop | 1 | | Lawrence D'Oliveiro |
| 1 Jul14:36 | Re: XDG and Freedesktop | 1 | | Rich |
| 1 Jul00:12 | Re: XDG and Freedesktop | 4 | | Nuno Silva |
| 1 Jul01:21 | Re: XDG and Freedesktop | 3 | | Lawrence D'Oliveiro |
| 1 Jul05:20 | Re: XDG and Freedesktop | 2 | | Eli the Bearded |
| 1 Jul05:25 | Re: XDG and Freedesktop | 1 | | Lawrence D'Oliveiro |
| 1 Jul18:00 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 4 | | candycanearter07 |
| 1 Jul20:29 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 3 | | Eli the Bearded |
| 2 Jul19:20 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 2 | | candycanearter07 |
| 3 Jul17:18 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | Eli the Bearded |
| 29 Jun11:30 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 9 | | Carlos E.R. |
| 30 Jun01:17 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 6 | | Fritz Wuehler |
| 30 Jun06:53 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 2 | | Eli the Bearded |
| 30 Jun07:55 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | Lawrence D'Oliveiro |
| 30 Jun07:05 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 3 | | c186282 |
| 30 Jun21:32 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 2 | | Eli the Bearded |
| 1 Jul01:34 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | Lawrence D'Oliveiro |
| 30 Jun08:40 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | The Natural Philosopher |
| 30 Jun13:03 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | Carlos E.R. |
| 27 Jun 25 | Re: Program to dole out jpg's to subdirctories, card-dealing style. | 1 | | Shadow |