Re: [Dbix-class] update a row only if any column has changed

2013-04-06 Thread Rajeev Prasad
...@yahoo.com; DBIx::Class user and developer list dbix-class@lists.scsys.co.uk Sent: Friday, April 5, 2013 10:01 PM Subject: Re: [Dbix-class] update a row only if any column has changed On Fri, Apr 5, 2013 at 7:45 PM, Rajeev Prasad rp.ne...@yahoo.com wrote: hello, I have a table with around

[Dbix-class] update a row only if any column has changed

2013-04-05 Thread Rajeev Prasad
hello, I have a table with around 2,000,000 records (15 columns). I have to sync this from an outside source once everyday. not all records are changed/removed /new-added everyday. so what is the best way to update only those which have changed/added/or deleted? i can use update_or_create but

Re: [Dbix-class] update a row only if any column has changed

2013-04-05 Thread Brendan Byrd
On Fri, Apr 5, 2013 at 7:45 PM, Rajeev Prasad rp.ne...@yahoo.com wrote: hello, I have a table with around 2,000,000 records (15 columns). I have to sync this from an outside source once everyday. not all records are changed/removed /new-added everyday. so what is the best way to update only