How fast should be loading 600 houses?
#1

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
Код:
[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"
and last house end in 23.15.19
Код:
[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"
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.

Код:
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);
}
How to make that faster?
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)