Re: [GENERAL] Queues Problem

2010-06-09 Thread uaca man
2010/6/8 Oliver Kohll - Mailing Lists > On 8 Jun 2010, at 20:12, uaca man wrote: > > > 2) Think of the front end as changing states as the user interacts > > with it, then figure out what queries need to be made to correspond to > > the changes in state. > > > [snip] > > > That is exactly what w

Re: [GENERAL] Queues Problem

2010-06-08 Thread Vick Khera
On Tue, Jun 8, 2010 at 2:01 PM, uaca man wrote: >> 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? You have work you need done

Re: [GENERAL] Queues Problem

2010-06-08 Thread uaca man
2010/6/8 Peter Hunsberger > On Tue, Jun 8, 2010 at 1:26 PM, uaca man wrote: > >> 2) Think of the front end as changing states as the user interacts > >> with it, then figure out what queries need to be made to correspond to > >> the changes in state. For example, it is unlikely the user needs t

Re: [GENERAL] Queues Problem

2010-06-08 Thread Peter Hunsberger
On Tue, Jun 8, 2010 at 1:26 PM, uaca man wrote: >> 2) Think of the front end as changing states as the user interacts >> with it, then figure out what queries need to be made to correspond to >> the changes in state.  For example, it is unlikely the user needs the >> amount of "gold" updated every

Re: [GENERAL] Queues Problem

2010-06-08 Thread Andy Colson
On 6/8/2010 1:26 PM, uaca man wrote: > 2) Think of the front end as changing states as the user interacts > with it, then figure out what queries need to be made to correspond to > the changes in state. For example, it is unlikely the user needs the > amount of "gold" updated every 5 seconds

Re: [GENERAL] Queues Problem

2010-06-08 Thread uaca man
> 2) Think of the front end as changing states as the user interacts > with it, then figure out what queries need to be made to correspond to > the changes in state. For example, it is unlikely the user needs the > amount of "gold" updated every 5 seconds. Rather, they need to know > how much the

Re: [GENERAL] Queues Problem

2010-06-08 Thread Peter Hunsberger
On Tue, Jun 8, 2010 at 1:00 PM, uaca man wrote: > This would work except for one thing, the building may affect another > buildings, Consider this: > > the user starts one construction that will finish in 10 minutes and the > building will give a bonus of +5 gold each seconds for the user. This ha

Re: [GENERAL] Queues Problem

2010-06-08 Thread uaca man
>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, application

Re: [GENERAL] Queues Problem

2010-06-08 Thread uaca man
This would work except for one thing, the building may affect another buildings, Consider this: the user starts one construction that will finish in 10 minutes and the building will give a bonus of +5 gold each seconds for the user. This has to be available in the seconds that the build is done an

[GENERAL] Queues Problem

2010-06-08 Thread uaca man
Hello my fellow postgreSQL gurus. I´m a user of postgresSQL of quite some time now, but most of my experience is consuming database, and for the current project we are without a proper DBA and they have to bear with me and so I must seek advice. I have a list of building and a queue and the user

Re: [GENERAL] Queues Problem

2010-06-08 Thread Andy Colson
On 6/8/2010 11:53 AM, uaca man wrote: Hello my fellow postgreSQL gurus. I´m a user of postgresSQL of quite some time now, but most of my experience is consuming database, and for the current project we are without a proper DBA and they have to bear with me and so I must seek advice. I have a lis

Re: [GENERAL] Queues Problem

2010-06-08 Thread Vick Khera
On Tue, Jun 8, 2010 at 12:53 PM, uaca man 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

[GENERAL] Queues Problem

2010-06-08 Thread uaca man
Hello my fellow postgreSQL gurus. I´m a user of postgresSQL of quite some time now, but most of my experience is consuming database, and for the current project we are without a proper DBA and they have to bear with me and so I must seek advice. I have a list of building and a queue and the user