Search Postgresql Archives

Re: Queues Problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>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@xxxxxxxxx>
On Tue, Jun 8, 2010 at 12:53 PM, uaca man <uacaman@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux