15.04.2016, 14:41
If you have 661 houses, the size of House array shouldn't be 800 but 670-675 and if needed more, changing the slot and restart the server wouldn't be a problem.
Anyway, as for your queries. Use cache_get_row/cache_get_row_* functions instead because retrieving the field's name requires more time that just a number.
I still recommended using threaded queries (mysql_pquery is used for more than 1 connection) though.
Last, more of a question. You do have an hID in your table so why you use "b" and start indexes from 1 when 0 can be used too?
Anyway, as for your queries. Use cache_get_row/cache_get_row_* functions instead because retrieving the field's name requires more time that just a number.
I still recommended using threaded queries (mysql_pquery is used for more than 1 connection) though.
Last, more of a question. You do have an hID in your table so why you use "b" and start indexes from 1 when 0 can be used too?