If you configure the dual monitors through the Nvidia control panel, set
them for separate X screen logins, and then enable Xinerama, you get the
ability to move windows from one screen to the other.
Tuxpaint --fullscreen expands to fill one of the monitors, but not both.
2009/10/21 Bill
Ok, so I've got a few queries our website does that
are used to determine which products are 'top sellers'
in the past 90 days' worth of sales.
Right now, this involves joining the product table
with the orders table, by way of an items-in-the-order table.
In other words, to figure out what
On Tue, Dec 01, 2009 at 05:32:20PM -0800, Bill Kendrick wrote:
Anyone feel like flexing their MySQL muscles and provide some
ideas on how to populate a similar table (tracking sales) based
on the orders/orderitem table combo explained above?
Thanks. Sorry for asking you to do my (home)work
On Tue, Dec 01, 2009 at 08:04:31PM -0600, Chanoch (Ken) Bloom wrote:
Is this task getting more intensive?
I think so, but it's hard to tell, with other things going on
at the same time.
If is (and the number of
transactions per day hasn't grown significantly),
Site traffic has been
On Wed, Dec 02, 2009 at 12:20:25AM -0600, Chanoch (Ken) Bloom wrote:
INSERT into orderstats(productid, date, orders)
SELECT
orderitem.productid, orders.timestamp, SUM(orderitem.qty)
FROM orderitem
JOIN orders ON orders.id = orderitem.orderid
WHERE orders.timestamp = { 90 days ago }
On Tue, 2009-12-01 at 22:33 -0800, Bill Kendrick wrote:
On Wed, Dec 02, 2009 at 12:20:25AM -0600, Chanoch (Ken) Bloom wrote:
INSERT into orderstats(productid, date, orders)
SELECT
orderitem.productid, orders.timestamp, SUM(orderitem.qty)
FROM orderitem
JOIN orders ON orders.id =
Hrm, trying to figure out a non-proprietary question ask, that would be useful.
Ah, how about what is the ratio between:
(unique orderitem.productid today)
--
orders today
Assuming it's high you could make it much easier to deal with by building a
table