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

<div align="left"><font face="Arial" size="2"><span style="font-size:10pt">On 17 Aug 2006 at 20:58, Peter Hardman
wrote:</span></font></div><divalign="left"><font face="Arial" size="2"><span style="font-size:10pt"><br
/></span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span style="font-size:10pt">>
</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span style="font-size:10pt">>
</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> On
16Aug 2006 at 17:48, Peter Hardman wrote:</span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> </span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> > I'm in the process of migrating a Paradox 7/BDE 5.01 database from
single-user</span></font></div><div align="left"><font color="#7f0000" face="Arial" size="2"><span
style="font-size:10pt">>> Paradox to a web based interface to either MySQL or PostgreSQL.</span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> <snip>
</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span style="font-size:10pt">>
</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> I've
uploadedmy data to www.shetland-sheep.org.uk/pgdata/sheep-flock.zip</span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"><span style="font-size:10pt"><br /></span></font></div><div align="left"><font
face="Arial"size="2"><span style="font-size:10pt">Sorry - that should be </span></font><font color="#7f0000"
face="Arial"size="2"><span
style="font-size:10pt">www.shetland-sheep.org.uk/pgdata/sheep_flock.zip</span></font></div><divalign="left"><font
color="#7f0000"face="Arial" size="2"><span style="font-size:10pt">> </span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"><span style="font-size:10pt">> The flock SSBXXX is the 'big flock in the sky'
andthus there should never be any </span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> date for a sheep greater than this. </span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> </span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> Yes, the primary key is
regn_no+ flock_no + transfer_date.</span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> </span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> Thanks again for all the help and advice.</span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> </span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> Regards,--
</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span style="font-size:10pt">>
PeterHardman</span></font></div><div align="left"><font color="#7f0000" face="Arial" size="2"><span
style="font-size:10pt">>Acre Cottage, Horsebridge</span></font></div><div align="left"><font color="#7f0000"
face="Arial"size="2"><span style="font-size:10pt">> King's Somborne</span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"><span style="font-size:10pt">> Stockbridge</span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> SO20
6PT</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span style="font-size:10pt">>
</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> ==
Breederof Shetland Cattle and Shetland Sheep ==</span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> </span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> </span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> ---------------------------(end of
broadcast)---------------------------</span></font></div><divalign="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">> TIP 2: Don't 'kill -9' the postmaster</span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">> </span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt"><br /></span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">-- </span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"><span style="font-size:10pt">Peter
Hardman</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"><span
style="font-size:10pt">AcreCottage, Horsebridge</span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><spanstyle="font-size:10pt">King's Somborne</span></font></div><div align="left"><font color="#7f0000"
face="Arial"size="2"><span style="font-size:10pt">Stockbridge</span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"><span style="font-size:10pt">SO20 6PT</span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"><span style="font-size:10pt"><br /></span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"><span style="font-size:10pt">== Breeder of Shetland Cattle and Shetland Sheep
==</span></font></div><divalign="left"></div>