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.
>
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.
>
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
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.
>
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
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
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
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