Hi!?
It's my first time posting here but I would like to know is there any possibilities that I can optimize this code? It causes a huge lag spike in the server when used in a live server. It occurs when this loop is called when removing a furniture/land object or removing the entire furniture/land object.?(This also happens when the script has to reload the furniture/land object)
The lag can also be noticed?when deleting a house (which removes all the furniture in the process)
Things to know; My server has 16,000 objects so it is no surprise that the loop will check each single objects in the server.
I will be showing the functions (codes) that calls the loop:
RemoveFurniture(objectid)
{
? ? if(IsValidDynamicObject(objectid) && Streamer_GetExtraInt(objectid, E_OBJECT_TYPE) == E_OBJECT_FURNITURE)
{
new
? ? ? ? id = Streamer_GetExtraInt(objectid, E_OBJECT_INDEX_ID);
? ? DeleteFurnitureObject(objectid);
? ? mysql_format(mysql_connection, queryBuffer, sizeof(queryBuffer), "DELETE FROM furniture WHERE id = %i", id);
? ? mysql_tquery(mysql_connection, queryBuffer);
}
}
DeleteFurnitureObject(objectid)
{
if(IsValidDynamicObject(objectid) && Streamer_GetExtraInt(objectid, E_OBJECT_TYPE) == E_OBJECT_FURNITURE)
{
? ? new Text3D:textid = Text3D:Streamer_GetExtraInt(objectid, E_OBJECT_3DTEXT_ID);
? ? ? ? if(IsValidDynamic3DTextLabel(textid))
? ? ? ? {
? ? ? ? ? ? DestroyDynamic3DTextLabel(textid);
? ? ? ? }
? ? ? ? DestroyDynamicObject(objectid);
}
}
RemoveAllFurniture(houseid)
{
? ? if(HouseInfo > 0)
{
? ? for(new i = 0; i <= Streamer_GetUpperBound(STREAMER_TYPE_OBJECT); i )
? ? {
? ? ? ? if(IsValidDynamicObject(i) && Streamer_GetExtraInt(i, E_OBJECT_TYPE) == E_OBJECT_FURNITURE && Streamer_GetExtraInt(i, E_OBJECT_EXTRA_ID) == HouseInfo)
? ? ? ? {
? ? ? ? ? ? DeleteFurnitureObject(i);
}
}
mysql_format(mysql_connection, queryBuffer, sizeof(queryBuffer), "DELETE FROM furniture WHERE houseid = %i", HouseInfo);
mysql_tquery(mysql_connection, queryBuffer);
}
}
ReloadFurniture(objectid, labels)
{
if(IsValidDynamicObject(objectid) && Streamer_GetExtraInt(objectid, E_OBJECT_TYPE) == E_OBJECT_FURNITURE)
{
? ? new
? ? ? ? id = Streamer_GetExtraInt(objectid, E_OBJECT_INDEX_ID);
? ? DeleteFurnitureObject(objectid);
? ? mysql_format(mysql_connection, queryBuffer, sizeof(queryBuffer), "SELECT * FROM furniture WHERE id = %i", id);
? ? mysql_tquery(mysql_connection, queryBuffer, "SQL_LoadFurnitures", "i", labels);
}
}
ReloadAllFurniture(houseid)
{
? ? if(HouseInfo > 0)
{
? ? for(new i = 0; i <= Streamer_GetUpperBound(STREAMER_TYPE_OBJECT); i )
? ? {
? ? ? ? if(IsValidDynamicObject(i) && Streamer_GetExtraInt(i, E_OBJECT_TYPE) == E_OBJECT_FURNITURE && Streamer_GetExtraInt(i, E_OBJECT_EXTRA_ID) == HouseInfo)
? ? ? ? {
? ? ? ? ? ? DeleteFurnitureObject(i);
}
}
mysql_format(mysql_connection, queryBuffer, sizeof(queryBuffer), "SELECT * FROM furniture WHERE houseid = %i", HouseInfo);
mysql_tquery(mysql_connection, queryBuffer, "SQL_LoadFurnitures", "i", HouseInfo);
}
}
I will be editing this thread if more codes are needed.