refresh of cash amount

Guest · Post by **Guest** » 14.04.2007, 04:01

Yeah I know what you're saying balaam. Here is why it's a problem:

Any time you clicked any page it would have to check all your stores. That's an unnecessary DB load, to save you a few clicks and web page refreshes when you want cash faster.

Plus as several as several of us have said, we rather like it this way. I can understand why you'd want the change. And if you have more stores than I do, and/or like to run very "just in time" with your cash and inventory, then then it probably affects you more than me. But for technical and usage reasons, I really don't think it will happen.

Guest · Post by **Guest** » 14.04.2007, 10:55

no

I want it accurate when I check four or five time a day.
I don't need real time.

Guest · Post by **Guest** » 14.04.2007, 11:10

If you have that many stores use an administrative building.

Guest · Post by **Guest** » 14.04.2007, 14:12

balaam wrote:no

I want it accurate when I check four or five time a day.
I don't need real time.

But, since there's no way to know what points in time that you are going to decide that you want to check your stores, they would have to process the transactions in real-time just to make sure that the values are available for that moment when you do decide to check in.

Given the server loads that would require, it's not likely to happen.

Guest · Post by **Guest** » 14.04.2007, 16:20

tsss tsss

the server do calculate the needed time to complet sells , products sell per second ratio and benefit per second ratio. these are Constants that are already there.

all sell/produce/upgrade webpages contain a time countdown.

a mere VBscript or java bean can calculate benefits and products left by the formulaes
(sell time planned - sell time remaining) * products sell per second ratio
and
(sell time planned - sell time remaining) * benefit per second ratio

no server call, only local variables and functions.
only a button to launch the process or an autolaunch when changing page.

if I can do it on excel with arithmetic functions, professionals programmers can certainly do it on a webpage with whatever language they are fond of.

Guest · Post by **Guest** » 14.04.2007, 17:51

no server call, only local variables and functions.

There is a DB call. Several in fact.

Every building has the completion time ready for display externally, and that functionality is already built, so I'll give you the benefit and treat it as local, as you say. You still need queries to:

1. Retrieve price from every building
2. Retrieve quantity from every building

Then you calculate the profit as you said.

3. Update sales table with new quantity for every building
4. Update sales table with current time as new start time. For each building..
5. Update cash balance with new calculated amount.

And that would have to be done every page refresh whether its wanted or not just so its done when you do want it.

Not going to happen.

The best compromise you could hope for is one button, probably on the Sales page, that will update from all your stores at once. That way it does the list I said, but only when you want it. But I think that's what the Admin building does anyway?

And look on the bright side. Sales buildings could have been made like Producing buildings. If that were the case, you wouldn't get any money at all until the whole thing is finished.

Guest · Post by **Guest** » 14.04.2007, 18:37

Hey cool, Knolls said it before I actually bothered to type it all out!

Yeah, there's a ton of DB (database) calls involved in updating a single store, and DB calls, unlike the simple math equations you posited, are much, much, much, much, more computationally expensive. And no, there's no way to get around it.

Guest · Post by **Guest** » 14.04.2007, 21:45

balaam wrote:tsss tsss

the server do calculate the needed time to complet sells , products sell per second ratio and benefit per second ratio. these are Constants that are already there.

all sell/produce/upgrade webpages contain a time countdown.

a mere VBscript or java bean can calculate benefits and products left by the formulaes
(sell time planned - sell time remaining) * products sell per second ratio
and
(sell time planned - sell time remaining) * benefit per second ratio

no server call, only local variables and functions.
only a button to launch the process or an autolaunch when changing page.

if I can do it on excel with arithmetic functions, professionals programmers can certainly do it on a webpage with whatever language they are fond of.

Those are just simple things like timers dude. It's way easy and very low on server resources.

What you're asking is for something that requires more load because it has to calculate a lot of stuff.

Plus, as has been stated, the feature already does exist.

You need to get an administrative building for that

Tycoon · Post by **Tycoon** » 14.04.2007, 21:48

I am quite sure that nearly 80% of the users would not want to have the system emptying the stores before they decide to do so... so that won't be implemented here, even if it is / would be the easiest job to do for the programmers...