Re: [LUG] furthering the revolution: ECDL

[kevin bailey <kevin_bailey@xxxxxxxxxxx>]

> Postgres and MySQL can combine well by having all the transactions 
> (updates, etc) handled by Postgres and then Have MySQL update itself from 
> Postgres when its not too busy and otherwise concentrating on pushing out 
> results as quick as it can.


hmm.. interesting...

> It should be quicker to update N records in 1 go than to update N records 
> in N queries as there will be less locking and no contention / blocking.
>
>
> > i have to set up a postgres DB on a server soon and will be running some 
> > tests - i'll try to find time to set up MYSQL as well and run the same 
> > tests - i'll post any results/conclusions,
>
> You'll find that MySQL isn't case sensitive and Postgres is - if your 
> dirty has varying or poor capitalisation it can be a pig to clean it all. 
> Also Postgres uses ' instead of " for quoting values in queries. Finally 
> Postgres doesn't allow you to drop a column from a table - you have to 
> create a new table without teh column with data inserted by a great big 
> select - this can be a pig.
>
> regards,
> A.


cheers - kev




--
The Mailing List for the Devon & Cornwall LUG
Mail majordomo@xxxxxxxxxxxx with "unsubscribe list" in the
message body to unsubscribe.