On 02/09/13 22:40 -0700, Kaushik S wrote: > On Tuesday, September 3, 2013 2:08:20 AM UTC+5:30, Cédric Krier wrote: > > > I need to talk to an ldap server and get the latest records from a > > table. I > > > hope its ok to use ir.cron for this kind of a thing. If not, please > > > suggest. > > > > It sounds strange and calling such code every minutes shall probably not > > scale very well. > > But without knowing more about what it is, it is difficult to give > > advice. > > > > > ok. Thanks. We are looking for changes in an external database table. > This is a small database we are accessing. This table has around 10,000 > records. We might have 1 or 2 entries added a month. We just have to > maintain a list of all primary keys in this table. So, whenever a new entry > has been added, we need to know. It would be great if we can get a > notification but that is not in our control. We have to watch for new > updates. What is the best way to do this? Would you say we shouldn't use > a trigger at all?. Should we may be run an external daemon that looks > for changes and notifies gnu health?.
Still not enough information to answer. What is it stored in this DB? Why do you need to know new entries? What do you really need to do when new entries appear? Is there never deleted entries? Also you say it happens 1 or 2 times per month and you want to check it every minutes. Why do you need to spend soo much ressource for that? -- Cédric Krier B2CK SPRL Rue de Rotterdam, 4 4000 Liège Belgium Tel: +32 472 54 46 59 Email/Jabber: [email protected] Website: http://www.b2ck.com/
pgpAUz9qr7Mb6.pgp
Description: PGP signature
