01.07.2012, 01:18
A query like that wont be much faster than 10 structured and ordered small queries, maybe even slower. If your hoster limits the mysql queries that strict, so you need to care about single queries of the relatively rare called query code, you might consider switching to another one.
If your saving structure is well ordered you can update only the relevant parts that actually changed instead of updating everything ever stored for that player. This will give a great performance boost.
If your saving structure is well ordered you can update only the relevant parts that actually changed instead of updating everything ever stored for that player. This will give a great performance boost.