[iZN]

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.

You must be using threaded query along with cache or ORM-system? 50ms is perfect.

Quote:

Originally Posted by Anzipane 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..

What? MySQL is not like a magic wand which will give you like 5-10ms (If you're expecting that with a huge amount of data being loaded). "ALOT" is meaning like the OP just said 50 minutes lol, come on.