[SOLVED] Gaming and UPDATE LOW_PRIORITY

[Crusader]

Would using an "UPDATE LOW_PRIORITY" have any negative effects on a game?

 

I'm storing user positions in the database and updating their row whenever they move to a different area (which would be a lot).

 

UPDATE LOW_PRIORITY `players` 
SET `sector` = ?, `galaxy` = ?, `x` = ?, `y` = ? 
WHERE `game` = ? AND `player_id` = ? 
LIMIT 1

 

Before calling that statement this is initially run at the start of every page.

 

SELECT * 
FROM `players` 
WHERE `user_id` = ? AND `game` = ? 
LIMIT 1

 

Would this result in nobody being able to move until someone else has completed theirs? I don't want that to happen and am not sure how to test this. ???

 

Note: I believe table locking is set to off on mysqld.

[fenway]

Well, have you read the refman page on LOW_PRIORITY/

[Crusader]

Well that's where I learned about LOW_PRIORITY but it wasn't quite clear to me whether or not it would leave users in limbo until everyone else had finished moving/updating.

[fenway]

It's only "low" when compared to SELECT statements.

[Crusader]

Thanks!