Can we get a link showing how big an order is on an ask price?

For those selling they may be willing to fill an order, but would prefer not to send all their goods at the lower price.

or provide a report showing the various asking prices and quantities willing to buy next to each one.

Problem is you can set orders that are way bigger than what you can afford.

is there a way of adjusting the ask quantity based on a summarized cash on hand of n countries requesting?

Example: (i don't know the schema therefore... psuedo)

select askprice, sum(cashonhand), (sum(cashonhand) / askprice ) as qtyAsked

from countrymarket

where activecountry = 1

Group by askprice, sum(cashonhand), (sum(cashonhand) / askprice )

not atm.

mmm cash on hand is not stored in the market tables...

of course anything is possible, but it would probably be a prohibitively expensive query to do, especially an average of once per second

hmmm... make it for only one good at a time, and only run the query on demand

filter to countries that have ask orders for the particular resource and sum cash on hand from country table?

the join can be on country id (assuming ask price and resource is stored with a country id and table containing cash on hand also has a country id) --- where resource = @resource

just thinking out loud I guess

most joins are too slow for our query rates =/ demand for the market *is* around 1/second, especially due to feeds &etc; but even without it's fairly high

kk, did realize it was that resource intensive...

what about a tracking table that is updated via a trigger that is executed only if a country has an active standing order on the market and their cash on hand changes.

---------------------------------------------------------------------------------------------------
country id | resource | ask price | ask qty | cash on hand | active | buy power
---------------------------------------------------------------------------------------------------

update the ask price, ask qty, cash on hand, active and buy power when those change.

buy power = cash on hand / ask price

Deactivate any standing order when buy power = 0 or when ask qty = 0.