[Anzipane]

Quote:

Originally Posted by Neil. That enlightened it up fairly well. Just a while ago I did that for my Houses (where I would show the player the houses he owned.) instead of looping over 300 houses, I just did a query and it executed around 50ms. I don't know if that would hold up for a thousand of them though.

50ms is actually A LOT of time for a query to execute! Either your code is really inefficient or your database is not on the same machine as your samp-server..