Re: [GENERAL] [pgsql-advocacy] Me And My Database

2006-06-07 Thread Leif B. Kristensen
On Wednesday 7. June 2006 06:26, Robert Treat wrote: >On Tuesday 06 June 2006 18:44, Leif B. Kristensen wrote: >> The reason why the generation of eg. the family sheet is faster in >> the MySQL web context than in my production environment, is that I'm >> really comparing apples and potatoes here

Re: [GENERAL] [pgsql-advocacy] Me And My Database

2006-06-06 Thread Robert Treat
On Tuesday 06 June 2006 18:44, Leif B. Kristensen wrote: > On Wednesday 7. June 2006 00:10, Jim C. Nasby wrote: > >Moving to -general. > >From the bottom of that page: > > > >SELECT * FROM sources INTO src WHERE source_id = $1; > > > >SELECT * is generally something to avoid. You end up shoving

Re: [GENERAL] [pgsql-advocacy] Me And My Database

2006-06-06 Thread Leif B. Kristensen
On Wednesday 7. June 2006 00:10, Jim C. Nasby wrote: >Moving to -general. >From the bottom of that page: > >SELECT * FROM sources INTO src WHERE source_id = $1; > >SELECT * is generally something to avoid. You end up shoving around > more data than needed. Granted, in this case it's only gettin

Re: [GENERAL] [pgsql-advocacy] Me And My Database

2006-06-06 Thread Jim C. Nasby
Moving to -general. On Fri, Jun 02, 2006 at 10:45:14PM +0200, Leif B. Kristensen wrote: > Don't know if it's relevant here, but I've recently launched the third > article in a series on my transition from shrink-wrapped genealogy > software on Windows to my own custom PostgreSQL/PHP application