From: | uaca man <uacaman(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Queues Problem |
Date: | 2010-06-08 18:01:16 |
Message-ID: | AANLkTikt2-2wCWtxlgI553lhJT6HoIun06w_j_HfZ3l5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>You should investigate a proper queueing or job scheduling solution,
>such as RabbitMQ or Qpid or gearman. They are designed for this type
>of requirement.
All of those(RabbitMQ , Qpid and gearman) are messages queue and are used to
exchange message between different process, system, applications or whatever
you like, much like IBM MQSeries Plataform.
I don’t see how this is related to problem. Did is miss something?
> You will have to write your code to be more event
>driven, and make the web server just generate requests and view the
>results where they are stored.
What do you mean? That is what I think I am trying to do. No?
2010/6/8 Vick Khera <vivek(at)khera(dot)org>
> On Tue, Jun 8, 2010 at 12:53 PM, uaca man <uacaman(at)gmail(dot)com> wrote:
> > Lets say for a 20 thousand users server, it may have at most 20 thousand
> > constructions started at the same time.
> >
> > To accomplish such behavior so far I could come up with two options:
> >
> > 1. Make a never ending function that will look at the
> BuildingQueue
> > table every second and finish the construction.
> >
> > 2. Every time the user start a construction add a cron job for that
> > construction to run 1 seconds after the construction is finished and call
> a
> > function the will finish.
>
> You should investigate a proper queueing or job scheduling solution,
> such as RabbitMQ or Qpid or gearman. They are designed for this type
> of requirement. You will have to write your code to be more event
> driven, and make the web server just generate requests and view the
> results where they are stored.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Amiel | 2010-06-08 18:04:38 | Re: 3rd time is a charm.....right sibling is not next child crash. |
Previous Message | uaca man | 2010-06-08 18:00:35 | Re: Queues Problem |