Re: PostgreSQL runs a query much slower than BDE and MySQL - Mailing list pgsql-performance

From Peter Hardman
Subject Re: PostgreSQL runs a query much slower than BDE and MySQL
Date
Msg-id 44E4DEC1.20511.10CA34D@peter.ssbg.zetnet.co.uk
Whole thread Raw
In response to Re: PostgreSQL runs a query much slower than BDE and MySQL  ("Peter Hardman" <peter@ssbg.zetnet.co.uk>)
List pgsql-performance
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.
> <snip>
>
> I've uploaded my data to www.shetland-sheep.org.uk/pgdata/sheep-flock.zip

Sorry - that should be www.shetland-sheep.org.uk/pgdata/sheep_flock.zip
>
> The flock SSBXXX is the 'big flock in the sky' and thus there should never be any
> date for a sheep greater than this.
>
> Yes, the primary key is regn_no + flock_no + transfer_date.
>
> Thanks again for all the help and advice.
>
> Regards,--
> Peter Hardman
> Acre Cottage, Horsebridge
> King's Somborne
> Stockbridge
> SO20 6PT
>
> == Breeder of Shetland Cattle and Shetland Sheep ==
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Peter Hardman
Acre Cottage, Horsebridge
King's Somborne
Stockbridge
SO20 6PT

== Breeder of Shetland Cattle and Shetland Sheep ==

pgsql-performance by date:

Previous
From: "Peter Hardman"
Date:
Subject: Re: PostgreSQL runs a query much slower than BDE and MySQL
Next
From: Scott Lamb
Date:
Subject: Re: PostgreSQL runs a query much slower than BDE and MySQL