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
