Quote:
Originally Posted by Konstantinos
It takes so much because you load 660 times the already loaded data. Do not use loop, the query itself selects ALL the data from the table.
EDIT: That's how it should be assuming hID is set to AUTO_INCREMENT.
pawn Код:
mysql_tquery(server, "SELECT * FROM houses", "LoadHouses","");
pawn Код:
forward LoadHouses();
public LoadHouses()
{
new rows = clamp(cache_get_row_count(server), 0, sizeof House - 1);
for(new b; b != rows; ++b)
{
House[b][hID] = cache_get_row_int(b, 0);
House[b][hEnterX] = cache_get_row_float(b, 1);
House[b][hEnterY] = cache_get_row_float(b, 2);
House[b][hEnterZ] = cache_get_row_float(b, 3);
House[b][hExitX] = cache_get_row_float(b, 4);
House[b][hExitY] = cache_get_row_float(b, 5);
House[b][hExitZ] = cache_get_row_float(b, 6);
House[b][hCarX] = cache_get_row_float(b, 7);
House[b][hCarY] = cache_get_row_float(b, 8);
House[b][hCarZ] = cache_get_row_float(b, 9);
House[b][hCarZ] = cache_get_row_float(b, 10);
cache_get_row(b, 11, House[b][hOwner]);
House[b][hCost] = cache_get_row_int(b, 12);
House[b][hInt] = cache_get_row_int(b, 13);
House[b][hVW] = cache_get_row_int(b, 14);
House[b][hLock] = cache_get_row_int(b, 15);
House[b][hKlass] = cache_get_row_int(b, 16);
}
}
|
with Pquery, not tquery like u said it still getting 47 seconds to load all houses
with Tquery right the same: 47-48 seconds.
Cant understand this sheeeit
