[Tilesathome] Request priorities

[Matthias Julius]

Stefan Agner <falstaff at deheime.ch> writes:

> On Mon, 29 Oct 2007 23:40:06 -0400, Matthias Julius <lists at julius-net.net>
> wrote:
>> 80n <80n80n at gmail.com> writes:
>>> Yes, something like this is needed.  The system is very unresponsive to
>>> manual requests at the moment.
>> 
>> The attached patch for NeedRender/index.php should just do that (I
>> hope, not tested).
> Why dont you use the ON DUPLICATE KEY UPDATE statements? That would reduce
> mysql load... (I don't checked if its possible in this case, but as I read
> the idea, my first idea was this statement...)

There are more conditions for the update than a duplicate key. An
update is only made if the request is pending and the new priority is
higher (lower number) than the existing one. Can you capture that into
one SQL statement?

>
>> Anyway, I think informationfreeway.org should be exempted from that
>> since requests from there are actually coming from many different
>> users.
> Why? The requests are made from the users IP address, or am I wrong?

No, you're right. I guess I had a dark moment last night. I just saw a
lot of requests from infofreeway with priority 3 in the list and made
wrong conclusions.

Matthias