[SwiftEmu] Slow on boot? Bug or?

Results 1 to 5 of 5
  1. #1
    LETS REACH 666 POSTS?!!!! ImNotSatan is offline
    MemberRank
    Apr 2013 Join Date
    google.devLocation
    573Posts

    [SwiftEmu] Slow on boot? Bug or?

    Hey, my swift emu, takes like 2 minutes to boot due tha catalogue cache

    Is it supposed to take that long?

    Becouse other Emu's dont take that long to boot

    So yeah?

    Anny others having this?

    EDIT: Sledmore fixed it remove this query:

    dbClient.runFastQuery("UPDATE catalog_items_copy,items_base SET catalog_items_copy.amount = 1 WHERE items_base.allow_gift = 1 AND catalog_items_copy.amount > 1");
    Last edited by ImNotSatan; 02-07-14 at 10:30 AM.


  2. #2
    Account Upgraded | Title Enabled! Sledmore is offline
    MemberRank
    Jun 2009 Join Date
    1,133Posts

    Re: [SwiftEmu] Slow on boot? Bug or?

    If I remember rightly, there is a query just where the catalog initializes that updates some data, that query isn't needed once ran the first time, you can remove it and then compile the solution and it'll be fine.

  3. #3
    LETS REACH 666 POSTS?!!!! ImNotSatan is offline
    MemberRank
    Apr 2013 Join Date
    google.devLocation
    573Posts

    Re: [SwiftEmu] Slow on boot? Bug or?

    Quote Originally Posted by Sledmore View Post
    If I remember rightly, there is a query just where the catalog initializes that updates some data, that query isn't needed once ran the first time, you can remove it and then compile the solution and it'll be fine.
    Mmmm im not sure what you mean i found this:

    internal void Initialize(IQueryAdapter dbClient)
    {
    this.Pages = new Dictionary<int, CatalogPage>();
    this.EcotronRewards = new List<EcotronReward>();
    this.gifts = new Hashtable();
    dbClient.runFastQuery("UPDATE catalog_items_copy,items_base SET catalog_items_copy.amount = 1 WHERE items_base.allow_gift = 1 AND catalog_items_copy.amount > 1");
    dbClient.setQuery("SELECT * FROM catalog_pages ORDER BY order_num");
    DataTable table = dbClient.getTable();
    dbClient.setQuery("SELECT * FROM ecotron_rewards ORDER BY item_id");
    DataTable table2 = dbClient.getTable();
    Hashtable cataItems = new Hashtable();
    dbClient.setQuery("SELECT * FROM catalog_items_copy");
    DataTable table3 = dbClient.getTable();
    if (table3 != null)
    {
    foreach (DataRow row in table3.Rows)
    {
    if (!string.IsNullOrEmpty(row["item_ids"].ToString()) && (((int)row["amount"]) > 0))
    {
    cataItems.Add(Convert.ToUInt32(row["id"]), new CatalogItem(row));
    }
    }
    }

    But removing that didnt make it faster :|

    Could you give more info about it?

    EDIT:
    I tink this is the part wich takes really long

    dbClient.setQuery("SELECT * FROM catalog_items_copy");
    DataTable table3 = dbClient.getTable();

    Altough it has like the Mysql 30% CPU for like 1 min

    If i enter SELECT * FROM catalog_items_copy in navicat its done in a second


    EDIT2:

    Randomly its waaaaaaay faster now thankyou so much :D!!!
    Last edited by ImNotSatan; 02-07-14 at 10:20 AM.

  4. #4
    Account Upgraded | Title Enabled! Sledmore is offline
    MemberRank
    Jun 2009 Join Date
    1,133Posts

    Re: [SwiftEmu] Slow on boot? Bug or?

    Removing the query you have highlighted should significantly improve the speed, I was updating Swift yesterday to release as I found people still use it, and removing that specific query improved the load up for myself.

  5. #5
    LETS REACH 666 POSTS?!!!! ImNotSatan is offline
    MemberRank
    Apr 2013 Join Date
    google.devLocation
    573Posts

    Re: [SwiftEmu] Slow on boot? Bug or?

    Quote Originally Posted by Sledmore View Post
    Removing the query you have highlighted should significantly improve the speed, I was updating Swift yesterday to release as I found people still use it, and removing that specific query improved the load up for myself.
    Do you also may have a fix for the user_pets bug?
    Or te bots?



Advertisement