If I can offload the calculations to MySQL, I'd be happy.
This works for MySQL 4:
SELECT MAX( amount ) FROM `bids` WHERE proxy !=1 GROUP BY item_id
...and then I'd need to total the amounts from each item.
But, with subquery support in MySQL 5, I can do this:
SELECT SUM(amount) FROM bids WHERE amount = ANY (SELECT MAX(amount)
as amount FROM bids WHERE proxy !=1 GROUP BY item_id)
That gets me the total raised straight out of the db. :)
-- Patrick
On Jan 19, 2007, at 10:57 am, Chris Abad wrote:
SELECT * FROM bids WHERE proxy != 1 ORDER BY amount DESC, time DESC
.. then do your sorting by item in Ruby. guess you could benchmark
it to see which way is faster. not sure if that's what you were
looking for...
On Jan 19, 2007, at 10:54 AM, Patrick Crowley wrote:
SELECT * FROM bids WHERE (item_id = 1 AND proxy != 1) ORDER BY
amount DESC, time DESC
_______________________________________________
Sdruby mailing list
[email protected]
http://lists.sdruby.com/mailman/listinfo/sdruby
_______________________________________________
Sdruby mailing list
[email protected]
http://lists.sdruby.com/mailman/listinfo/sdruby
