Hi, I am doing some optimizations on our app, and one thing I was
wondering is if I can have a lazy relation loading in a separate
thread.
The way I'd like to use it is like this. I have a list with products,
and these products show a graph with stock levels. To draw this graph,
the object fetches it's relation stock. The stock object is built like
this:
SELECT
amount - (SELECT sum(qty) FROM orders WHERE
id_product=stock.id_product) as available
FROM stock
WHERE id_product=1234;
This is because we need to correct stock levels with the already
placed orders to get a good idea of availability.
This query takes fairly long (depending on the orders) so I'd like to
draw a gray bar initially, start a thread to fetch the stock object
and draw it once we have that result. Is this possible? If so, can
anyone give me a hint how to start?
Thanks,
Koen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
