[SwiftEmu] Slow on boot? Bug or?

[ImNotSatan]

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");

[MentaL]

[Sledmore]

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.

[ImNotSatan]

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!!!

[Sledmore]

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.

[ImNotSatan]

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?