Re: selecting data for computation

[Tim Gustafson]

Hrmm, something didn't work quite right.  Here's the actual query:

select x, y, zoom from map_images where image_data_size = 0 and
get_lock(concat(x, ',', y, ',', zoom), 0) = 1 order by zoom
, sqrt(pow(x, 2) + pow(y, 2)) limit 1

I've added the image_data_size column and indexed it, and set its current
value to length(image_data), and modified my "update" query to set
image_data_size correctly once the job is done.

When I run more than one compute job, they all start processing the same
job simultaneously.  What am I missing?

Tim Gustafson
831-332-1496
tjg@stripped
http://tgustafson.com/