Re: [PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-17 Thread Peter Hardman
On 17 Aug 2006 at 20:58, Peter Hardman wrote: > > > On 16 Aug 2006 at 17:48, Peter Hardman wrote: > > > I'm in the process of migrating a Paradox 7/BDE 5.01 database from single-user > > Paradox to a web based interface to either MySQL or PostgreSQL. >

Re: [PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-17 Thread Peter Hardman
ator). As someone else suggested, these fields ought really to be CHAR no VARCHAR. I chose VARCHAR because the data mostly is shorter than the maximum lengths (although probably not enough to matter). I'd not really got into the subtleties of different behaviour of CHAR and VARCHAR. >

Re: [PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-17 Thread Peter Hardman
On 16 Aug 2006 at 17:48, Peter Hardman wrote: > I'm in the process of migrating a Paradox 7/BDE 5.01 database from > single-user > Paradox to a web based interface to either MySQL or PostgreSQL. I've uploaded my data to www.shetland-sheep.org.uk/pgdata/sheep-flock.zip

Re: [PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-17 Thread Peter Hardman
On 17 Aug 2006 at 12:11, Markus Schaber wrote: > Hi, Peter, > > Peter Hardman wrote: > > >> BTW, are you *sure* you are testing PG 8.1? The "Subquery Scan f2" plan > >> node looks unnecessary to me, and I'd have expected 8.1 to drop it out. >

Re: [PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-17 Thread Peter Hardman
On 16 Aug 2006 at 18:51, Tom Lane wrote: > "Peter Hardman" <[EMAIL PROTECTED]> writes: > > I'm in the process of migrating a Paradox 7/BDE 5.01 database from > > single-user Arjen van der Meijden has proposed a very elegant query in another post. > Wh

Re: [PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-17 Thread Peter Hardman
ne sheep if several were bought or registered on the same day. Forgive me for being verbose - I want to make sure I understand it propely myself! regards, -- Peter Hardman Acre Cottage, Horsebridge King's Somborne Stockbridge SO20 6PT == Breeder of Shetland Cattle and Shetland She

Re: [PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-16 Thread Peter Hardman
On 16 Aug 2006 at 20:02, Arjen van der Meijden wrote: > On 16-8-2006 18:48, Peter Hardman wrote: > > Using identically structured tables and the same primary key, if I run this > > on > > Paradox/BDE it takes about 120ms, on MySQL (5.0.24, local server) about > > 3

[PERFORM] PostgreSQL runs a query much slower than BDE and MySQL

2006-08-16 Thread Peter Hardman
rovement, but it's still an order of magnitude slower than MySQL. Can anyone suggest why PostgreSQL performs the original query so much slower than even BDE? -- Peter Hardman Acre Cottage, Horsebridge King's Somborne Stockbridge SO20 6PT == Breeder of Shetland Cattl