fatal error 102: table overflow: "staging buffer"
#4

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.
Reply


Messages In This Thread
fatal error 102: table overflow: "staging buffer" - by misticini - 01.07.2012, 00:46
Re: fatal error 102: table overflow: "staging buffer" - by Mauzen - 01.07.2012, 01:11
Re: fatal error 102: table overflow: "staging buffer" - by misticini - 01.07.2012, 01:13
Re: fatal error 102: table overflow: "staging buffer" - by Mauzen - 01.07.2012, 01:18

Forum Jump:


Users browsing this thread: 1 Guest(s)