this is for a billing system, at this point it's a toss-up b/w the
following:
1. a script grabs clients which need billing on a nightly basis
2. a script grabs clients which need billing for a particular time
interval (every hour, ever two hours etc...).
what methods are used for making this close to real-time - constant
polling?
thanks!
-lev
On 2 Jul 2002, Jason Earl wrote:
>
> If it only needs to be /fairly/ realtime, then you could use cron to
> fire a script every minute. Otherwise you could write an external
> long-running program that listens for notifies.
>
> Jason
>
> Lev Lvovsky <lists1@sonous.com> writes:
>
> > is it possible to create a trigger when the system time has reached the
> > date of a particular record? I know this is possible with an external
> > script, but I'm not quite sure how to go about making it fairly
> > real-time...
> >
> > thanks!
> > -lev
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
>
--
personal site :: www.sonous.com
rave site :: raves.sonous.com
I'm a DJ! site :: djkgb.sonous.com
"...is the best show on television. Its cooler than the other side of the
pillow." -Kevin King