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

Поиск
Список
Период
Сортировка
Искать
От
Peter Hardman
Тема
Re: PostgreSQL runs a query much slower than BDE and MySQL
Дата
Msg-id
44E4D86C.21053.F3E7E1@peter.ssbg.zetnet.co.uk
Ответ на
PostgreSQL runs a query much slower than BDE and MySQL (Peter Hardman)
Список
Дерево обсуждения
PostgreSQL runs a query much slower than BDE and MySQL "Peter Hardman" <peter@ssbg.zetnet.co.uk>
Re: PostgreSQL runs a query much slower than BDE and MySQL Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL runs a query much slower than BDE and MySQL "Peter Hardman" <peter@ssbg.zetnet.co.uk>
Re: PostgreSQL runs a query much slower than BDE and MySQL Markus Schaber <schabi@logix-tt.com>
Re: PostgreSQL runs a query much slower than BDE and MySQL "Peter Hardman" <peter@ssbg.zetnet.co.uk>
Re: PostgreSQL runs a query much slower than BDE and MySQL Markus Schaber <schabi@logix-tt.com>
Re: PostgreSQL runs a query much slower than BDE and MySQL Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL runs a query much slower than BDE and Mark Lewis <mark.lewis@mir3.com>
Re: PostgreSQL runs a query much slower than BDE and "Magnus Hagander" <mha@sollentuna.net>
Re: PostgreSQL runs a query much slower than BDE and MySQL Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL runs a query much slower than BDE and Simon Riggs <simon@2ndquadrant.com>
Re: PostgreSQL runs a query much slower than BDE and MySQL "Peter Hardman" <peter@ssbg.zetnet.co.uk>
Re: PostgreSQL runs a query much slower than BDE and MySQL Tom Lane <tgl@sss.pgh.pa.us>
Re: PostgreSQL runs a query much slower than BDE and MySQL Scott Lamb <slamb@slamb.org>
Re: PostgreSQL runs a query much slower than BDE and MySQL Scott Lamb <slamb@slamb.org>
Re: PostgreSQL runs a query much slower than BDE and MySQL Scott Lamb <slamb@slamb.org>
Re: PostgreSQL runs a query much slower than BDE and MySQL Arjen van der Meijden <acmmailing@tweakers.net>
Re: PostgreSQL runs a query much slower than BDE and MySQL "Peter Hardman" <peter@ssbg.zetnet.co.uk>
Re: PostgreSQL runs a query much slower than BDE and MySQL "Peter Hardman" <peter@ssbg.zetnet.co.uk>
Re: PostgreSQL runs a query much slower than BDE and MySQL "Peter Hardman" <peter@ssbg.zetnet.co.uk>
Re: PostgreSQL runs a query much slower than BDE and MySQL "Rodrigo De León" <rdeleonp@gmail.com> 


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

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 ==
В списке pgsql-performance по дате отправления
Предыдущее
От: Scott Lamb
Дата:
Следующее
От: Peter Hardman
Дата:
FAQ