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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux