15.04.2016, 13:54
(
Последний раз редактировалось BloodyRP; 15.04.2016 в 20:16.
)
Hello for everyone.
At the start I need to say u that my english is so poor and I'm sorry about that, but I rly need your help.
If I have 661 houses on gamemode and that all work with mysql r39-5 how much seconds that should get to load all info?
[More info]:
first house load in 23.14.31
and last house end in 23.15.19
So I want to ask a good pro coders. Is it normal to 48 secs load all information and save in variables? If not - what I need to do for fixing this? Thanks for every help.
How to make that faster?
At the start I need to say u that my english is so poor and I'm sorry about that, but I rly need your help.
If I have 661 houses on gamemode and that all work with mysql r39-5 how much seconds that should get to load all info?
[More info]:
first house load in 23.14.31
Код:
[23:14:31] [DEBUG] cache_get_row_int - row: 0, field_idx: 0, connection: 1 [23:14:31] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "1"
Код:
[23:15:19] [DEBUG] cache_get_row_int - row: 660, field_idx: 15, connection: 1 [23:15:19] [DEBUG] CMySQLResult::GetRowData - row: '660', field: '15', data: "0"
Код:
mysql_tquery(server, "SELECT * FROM houses", "LoadHouses"); forward LoadHouses(); public LoadHouses() { new time = GetTickCount(); for(new b; b != 660; ++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][hCarC] = 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); } printf("%d ms",GetTickCount()-time); }