Groups | Search | Server Info | Login | Register
Groups > comp.os.linux.misc > #60137
| From | rbowman <bowman@montana.com> |
|---|---|
| Newsgroups | comp.os.linux.misc |
| Subject | Re: The joy of Ada |
| Date | 2024-10-27 18:40 +0000 |
| Message-ID | <lo7fpbFc70iU2@mid.individual.net> (permalink) |
| References | (23 earlier) <lo2as5Fj476U1@mid.individual.net> <qn_SO.297938$EEm7.187626@fx16.iad> <vfif3b$3m055$4@dont-email.me> <y7aTO.203218$WtV9.22893@fx10.iad> <vfl257$bic6$4@dont-email.me> |
On Sun, 27 Oct 2024 09:46:15 +0000, The Natural Philosopher wrote: > I never bothered learning the more arcane side of SQL because if I ever > managed to get the query right, it was always so abysmally slow that it > was quicker to use a series of simple queries and join them together in > application code rather than SQL We had a support person who spent days if not months crafting a query using about every DB2 scalar function known to man. I forget the DB2 versions but it started to fail on an older one that only allowed a 4k buffer but worked on the newer ones that handled 8k. Being a series of CONCATs if anything in the chain returned null the whole thing failed. It was a work of art that was copied from site to site unchanged because nobody, including myself, could figure it out. When we needed an equivalent for SQL Server which didn't have some of the matching scalars I took the programming approach. I use joins sparingly but there reaches a point where you're being too cute and it's unmaintainable.
Back to comp.os.linux.misc | Previous | Next — Previous in thread | Next in thread | Find similar
Re: The joy of FORTRAN "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-20 00:13 -0400
Re: The joy of FORTH p.dean@invalid.net (Peter Dean) - 2024-10-20 06:22 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-20 07:03 +0000
Re: The joy of FORTH (not) p.dean@invalid.net (Peter Dean) - 2024-10-20 07:31 +0000
Re: The joy of FORTH Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-20 19:00 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-20 21:37 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-21 01:33 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-21 03:30 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-21 06:51 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-21 08:41 +0000
Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-21 07:55 -0700
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-21 20:53 +0000
Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-21 15:16 -0700
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-21 23:12 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-22 00:29 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-22 01:11 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-22 04:43 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-22 04:46 +0000
Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-22 09:59 -0700
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-22 20:52 +0000
Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-22 14:48 -0700
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-22 22:23 +0000
Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-22 15:36 -0700
Re: The joy of FORTH (not) magardner2010 <magardner2010@gmail.com> - 2024-10-23 14:33 +0300
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-23 21:00 +0000
Re: The joy of FORTH (not) magardner2010 <magardner2010@gmail.com> - 2024-10-24 06:45 +0300
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 03:54 +0000
Re: The joy of FORTH (not) "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-24 02:03 -0400
Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 06:36 +0000
Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-24 03:11 -0400
Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 20:50 +0000
Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-24 21:23 -0400
Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-25 17:32 +0000
Re: The joy of Ada rbowman <bowman@montana.com> - 2024-10-25 19:46 +0000
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-25 22:41 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-25 21:58 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-26 02:40 +0000
Re: The joy of SQL rbowman <bowman@montana.com> - 2024-10-26 06:02 +0000
Re: The joy of SQL p.dean@invalid.net (Peter Dean) - 2024-10-26 16:35 +0000
Re: The joy of SQL p.dean@invalid.net (Peter Dean) - 2024-10-26 16:52 +0000
Re: The joy of SQL rbowman <bowman@montana.com> - 2024-10-26 05:53 +0000
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-26 07:18 +0000
Re: The joy of SQL John Ames <commodorejohn@gmail.com> - 2024-10-28 08:04 -0700
Re: The joy of SQL Chris Ahlstrom <OFeem1987@teleworm.us> - 2024-10-28 11:33 -0400
Re: The joy of SQL "Kerr-Mudd, John" <admin@127.0.0.1> - 2024-10-28 17:59 +0000
Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-10-26 11:07 +0100
Re: The joy of SQL Lars Poulsen <lars@cleo.beagle-ears.com> - 2024-10-26 16:44 +0000
Re: The joy of SQL antispam@fricas.org (Waldek Hebisch) - 2024-10-26 18:48 +0000
Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-10-27 09:52 +0000
Re: The joy of SQL Mister Johnson <root@example.net> - 2024-10-27 13:00 +0000
Re: The joy of SQL rbowman <bowman@montana.com> - 2024-10-27 17:40 +0000
Re: The joy of SQL John Levine <johnl@taugh.com> - 2024-10-27 18:38 +0000
Re: The joy of SQL Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-28 02:42 +0000
Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-10-27 09:32 +0000
Re: The joy of SQL rbowman <bowman@montana.com> - 2024-10-27 17:35 +0000
Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-26 04:38 +0000
Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-26 05:39 +0000
Re: The joy of Ada The Natural Philosopher <tnp@invalid.invalid> - 2024-10-26 11:08 +0100
Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-26 18:01 +0000
Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-26 20:26 +0000
Re: The joy of Ada The Natural Philosopher <tnp@invalid.invalid> - 2024-10-27 09:46 +0000
Re: The joy of Ada rbowman <bowman@montana.com> - 2024-10-27 18:40 +0000
Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-27 21:30 +0000
Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-28 00:58 -0400
Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-28 05:09 +0000
Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-28 05:18 +0000
Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-29 04:56 +0000
Re: The joy of Linux Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-29 18:35 +0000
Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-30 00:14 +0000
Re: The joy of Linux rbowman <bowman@montana.com> - 2024-10-30 01:24 +0000
Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 02:00 -0400
Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-31 02:20 +0000
Re: The joy of Linux Lars Poulsen <lars@cleo.beagle-ears.com> - 2024-11-03 19:19 +0000
Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 23:28 +0000
Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-04 13:19 +0000
Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-04 22:13 +0000
Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-04 22:33 -0500
Re: The joy of Linux John Ames <commodorejohn@gmail.com> - 2024-11-04 14:26 -0800
Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-05 13:53 +0000
Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 01:40 -0400
Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 01:55 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-31 02:21 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-31 01:35 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-31 06:20 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-31 23:57 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-01 04:14 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-01 02:45 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-01 20:56 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 01:19 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-02 06:18 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 03:21 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 00:15 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 21:51 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 23:32 +0000
Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-11-02 11:49 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 21:48 -0400
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 23:30 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-03 20:36 -0500
Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-04 22:09 +0000
Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-05 01:54 -0500
Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 01:52 -0400
Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-25 21:40 -0400
Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-26 04:38 +0000
Re: The joy of Ada rbowman <bowman@montana.com> - 2024-10-26 06:27 +0000
Re: The joy of strong typing magardner2010 <magardner2010@gmail.com> - 2024-10-24 10:56 +0300
Re: The joy of Python Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 20:55 +0000
Re: The joy of FORTH (not) Peter Flass <peter_flass@yahoo.com> - 2024-10-24 17:13 -0700
Re: The joy of FORTH (not) "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-25 03:24 -0400
Re: The joy of FORTH (not) Jim Jackson <jj@franjam.org.uk> - 2024-10-23 14:41 +0000
Re: The joy of FORTH (not) Peter Flass <peter_flass@yahoo.com> - 2024-10-22 16:07 -0700
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-22 23:37 +0000
Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-23 08:04 -0700
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-23 20:57 +0000
Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-23 14:36 -0700
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-23 23:02 +0000
Re: The joy of FORTH (not) Peter Flass <peter_flass@yahoo.com> - 2024-10-24 17:13 -0700
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-25 01:32 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-25 01:50 +0000
Re: The joy of FORTH (not) Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-25 17:32 +0000
Re: The joy of FORTH (not) Rich Alderson <news@alderson.users.panix.com> - 2024-10-25 17:16 -0400
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-25 22:39 +0000
Re: The joy of FORTH (not) Peter Flass <peter_flass@yahoo.com> - 2024-10-25 18:48 -0700
Re: The joy of FORTH (not) Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-26 04:38 +0000
Re: The joy of FORTH (not) Lynn Wheeler <lynn@garlic.com> - 2024-10-25 22:59 -1000
Re: The joy of FORTH (not) Lynn Wheeler <lynn@garlic.com> - 2024-10-26 09:10 -1000
Re: The joy of FORTH (not) Lynn Wheeler <lynn@garlic.com> - 2024-10-26 12:35 -1000
Re: The joy of FORTH (not) Peter Flass <peter_flass@yahoo.com> - 2024-10-25 18:48 -0700
Re: Little old machines, The joy of FORTH (not) John Levine <johnl@taugh.com> - 2024-10-26 02:18 +0000
Re: Little old machines, The joy of FORTH (not) Peter Flass <peter_flass@yahoo.com> - 2024-10-26 13:25 -0700
Re: The joy of FORTH (not) antispam@fricas.org (Waldek Hebisch) - 2024-10-26 02:12 +0000
Re: The joy of FORTH (not) Peter Flass <peter_flass@yahoo.com> - 2024-10-25 18:48 -0700
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-26 06:11 +0000
Re: The joy of FORTH (not) The Natural Philosopher <tnp@invalid.invalid> - 2024-10-26 11:05 +0100
Re: The joy of FORTH (not) antispam@fricas.org (Waldek Hebisch) - 2024-10-25 11:01 +0000
Re: The joy of FORTH (not) antispam@fricas.org (Waldek Hebisch) - 2024-10-24 00:10 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 00:44 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-24 00:55 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 03:53 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-24 04:50 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-21 22:50 +0000
Re: The joy of FORTH (not) antispam@fricas.org (Waldek Hebisch) - 2024-10-23 22:25 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 00:46 +0000
Re: The joy of FORTH (not) "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-23 22:13 -0400
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 03:55 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-24 05:07 +0000
Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-24 08:03 -0700
Re: The joy of FORTH (not) p.dean@invalid.net (Peter Dean) - 2024-10-21 03:59 +0000
Re: The joy of FORTH (not) Marc Olschok <nobody@nowhere.invalid> - 2024-10-24 21:46 +0000
Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 22:29 +0000
Re: The joy of FORTH (not) Marc Olschok <nobody@nowhere.invalid> - 2024-10-27 20:30 +0000
Re: The joy of FORTH (not) rbowman <bowman@montana.com> - 2024-10-25 00:00 +0000
Re: The joy of FORTH (not) "Kerr-Mudd, John" <admin@127.0.0.1> - 2024-10-25 17:41 +0100
Re: The joy of FORTH (not) "Kerr-Mudd, John" <admin@127.0.0.1> - 2024-10-25 17:40 +0100
Re: The joy of FORTRAN John Ames <commodorejohn@gmail.com> - 2024-10-21 08:03 -0700
csiph-web