MySql loading - Printable Version

MySql loading - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySql loading (/showthread.php?tid=511957)

MySql loading - Porgand - 08.05.2014

PHP код:



funktsioon LoadProperty()

{

    new

        result[128], idx, sql[256];

    for(new i = 1; i <= kokkuMaju; i++)

    {

        format(sql, sizeof(sql), "SELECT * FROM `majad` WHERE `id` = '%d'", i);

        mysql_query(sql);

        mysql_store_result();

        if(mysql_fetch_row_format(sql,"|"))

        {

            mysql_fetch_field_row(result,"Owned"); KasutajaMajaInfo[i][hOwned] = strval(result);

            mysql_fetch_field_row(result,"Owner"); KasutajaMajaInfo[i][hOwner] = strval(result);

            mysql_fetch_field_row(result,"Description"); strmid(KasutajaMajaInfo[i][hDescription], result, 0, strlen(result), 255);//

            mysql_fetch_field_row(result,"Value"); KasutajaMajaInfo[i][hValue] = strval(result);

            mysql_fetch_field_row(result,"Level"); KasutajaMajaInfo[i][hLevel] = strval(result);

            mysql_fetch_field_row(result,"Locked"); KasutajaMajaInfo[i][hLocked] = strval(result);

            mysql_fetch_field_row(result,"LeaseDate"); KasutajaMajaInfo[i][hLeaseDate] = strval(result);

            mysql_fetch_field_row(result,"EntranceX"); KasutajaMajaInfo[i][hEntranceX] = floatstr(result);

            mysql_fetch_field_row(result,"EntranceY"); KasutajaMajaInfo[i][hEntranceY] = floatstr(result);

            mysql_fetch_field_row(result,"EntranceZ"); KasutajaMajaInfo[i][hEntranceZ] = floatstr(result);

            mysql_fetch_field_row(result,"InteriorX"); KasutajaMajaInfo[i][hInteriorX] = floatstr(result);

            mysql_fetch_field_row(result,"InteriorY"); KasutajaMajaInfo[i][hInteriorY] = floatstr(result);

            mysql_fetch_field_row(result,"InteriorZ"); KasutajaMajaInfo[i][hInteriorZ] = floatstr(result);

            mysql_fetch_field_row(result,"InteriorId"); KasutajaMajaInfo[i][hInterior] = strval(result);

            mysql_fetch_field_row(result,"HealthUpgrade"); KasutajaMajaInfo[i][hHealthUpgrade] = strval(result);

            mysql_fetch_field_row(result,"ArmourUpgrade"); KasutajaMajaInfo[i][hKappUpgrade] = strval(result);

            mysql_fetch_field_row(result,"RentAble"); KasutajaMajaInfo[i][hRentable] = strval(result);

            mysql_fetch_field_row(result,"Rent"); KasutajaMajaInfo[i][hRent] = strval(result);

            mysql_fetch_field_row(result,"Bank"); KasutajaMajaInfo[i][hBank] = strval(result);

            mysql_fetch_field_row(result,"Narko"); KasutajaMajaInfo[i][hProds] = strval(result);

            mysql_fetch_field_row(result,"Mats1"); KasutajaMajaInfo[i][hMats][0] = strval(result);

            mysql_fetch_field_row(result,"Mats2"); KasutajaMajaInfo[i][hMats][1] = strval(result);

            mysql_fetch_field_row(result,"Mats3"); KasutajaMajaInfo[i][hMats][2] = strval(result);

            mysql_fetch_field_row(result,"Address"); strmid(KasutajaMajaInfo[i][hAddress], result, 0, strlen(result), 64);

            idx++;

        }

        mysql_free_result();

    }

    printf("[MySQL] Loaded %d houses.", idx);

}

Help me to make it load faster

Re: MySql loading - MichealScript - 08.05.2014

Please say what is the proplem.

Re: MySql loading - Konstantinos - 08.05.2014

Execute only 1 query ("SELECT * FROM majad") and use mysql_retrieve_row.

That will improve your current code. You can make it loading much faster by updating the mysql plugin to R38 and using threaded queries.

Re: MySql loading - iZN - 08.05.2014

Quote:

Originally Posted by Porgand

Help me to make it load faster

You can't make it load fast. You're using the unthreaded queries which sucks hard, and they're freaking slow as compared to threaded queries. Search for cache tutorials for BlueG's MySQL plugin R7+ (the latest release is R38 now).

Re: MySql loading - Porgand - 08.05.2014

Yeah, I thought about the renewal but it is quite difficult and also specific skill is not.
iZN, you mean this tutorial: https://sampforum.blast.hk/showthread.php?tid=337810 ?