Summary:
Alright, so this is one of the methods to reduce the weapon switch lag, basically it will be easier to import data from the _Items DB. At the same time, this is bad for PvE servers because all the logs will be removed, pretty much if you drop an item on the group, it will be REMOVED 100% FROM THE GAME! unless someone picks it up then it will generate a new ID64.
Oh well this will make your GameServer cleaner and less laggy!
Objective
We going to remove the items from the game on drop! We also going to reduce the weapon switch lag for servers with 800+ people online!
Results
* Less lag and better performance!
Difficulty
Easy
-----------------------------------------------------------
- Please Execute the Following For the changes -
-----------------------------------------------------------
Before you try this!
Please reply below with:
1) Your _Items number before this!
2) Your _Items number after this!
You can use this query:
SELECT Count(*) FROM _Items
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_FREE_ITEM_NoTX] Script Date: 12/03/2011 04:26:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_STRG_FREE_ITEM_NoTX]
@ItemToFree bigint
as
if (not exists(select ItemID from _ItemPool with (nolock) where ItemID = @ItemToFree))
return -1
DELETE FROM _ItemPool where ItemID = @ItemToFree
DELETE FROM _Items WHERE ID64 = @ItemToFree
return 1
It's actually that easy!
Reducing the amount of items in _Items DB! + Weapon Switch lag!
Reply With Quote
Originally Posted by trytomakeserver
