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 Sheep ==
---(end of broadcast)---
TIP 1: if posting/reading
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
snip
Arjen van der Meijden has proposed a very elegant query in another post.
What I find interesting though is that it sounds
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.
8.0 and before would have left it in the plan though
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
The flock SSBXXX
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.
snip
Regards,--
Peter Hardman
Acre Cottage, Horsebridge
King's Somborne
Stockbridge
SO20 6PT
== Breeder of Shetland
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
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 Cattle and Shetland Sheep ==
---(end of broadcast
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
3ms,
and on PostgresSQL (8.1.3