[Geesu]

Basically I'd like to be able to execute a query with a given priority...

This is how it would work:

There are 2 queues, a high and a low priority. It doesn't matter when the low priorities are executed, as long as they are executed if their is nothing in the high priority.

So

while ( high priority queue exists )
- execute threaded query in here

then do the low priority ones.

I'm sure there is a more elegant solution than what I'm thinking, but this would be an EXTREME help as I have around 50 queries that need to be executed, but don't actually affect game play - but they are occuring before the other queries that do affect game play are.

Thanks!!
Josh

[BAILOPAN]

I can't see this happening any time soon but I'll leave the request up. It sounds like you have internal design issues.

[Geesu]

You have internal design issues

I'll try to talk to u on IRC when I get a chance

[BAILOPAN]

!!

[juKay]

Even if you do this the SQL server might as well give you the low priority query back first if it executes faster.

What you can do when using mysql is SELECT/INSERT [LOW_PRIORITY | HIGH_PRIORITY].

See http://dev.mysql.com/doc/refman/5.0/...rt-select.html for more information.

Why don't you just make a function in you script that executes your queries based on the priority you give them?