Performance issue with user icons and images

Disknoir

When testing a BS, I notice poor performance when using custom icons. The performance has slowly been degrading overtime.

When I check to see what MySql is doing, I see a select statement causing the delay:
SELECT * FROM DV_RES WHERE DataKey LIKE 'BASTestDomainRaithAsia_1.1380/Images/113/113/%'

State is Sending in MySql

It is taking 30 - 40 seconds per image file to send. Each file is a png around 2 to 4K.

Any ideas how to improve the performance??

MySql 5.6.11 x64
V5.8 (Build 1797)

Powerm

Try with MySql 5.5...

Disknoir

MySQl 5.5.37 x64

Much better - thanks!

hpl123

Disknoir wrote
When testing a BS, I notice poor performance when using custom icons. The performance has slowly been degrading overtime.

When I check to see what MySql is doing, I see a select statement causing the delay:
SELECT * FROM DV_RES WHERE DataKey LIKE 'BASTestDomainRaithAsia_1.1380/Images/113/113/%'

State is Sending in MySql

It is taking 30 - 40 seconds per image file to send. Each file is a png around 2 to 4K.

Any ideas how to improve the performance??

MySql 5.6.11 x64
V5.8 (Build 1797)

Disknoir,
Also update to the newest version of Aware IM. In build 1811 Awaresoft found and fixed a bug where Aware IM did not properly delete old temp files/entries. The bug was concerning DB MySQL. To see if this is the case for you, browse the DV_RES table in your TEST DB. I for example had almost 100.000 files/entries in the DEV_RES table and over time my application got slower and slower until it was practically unusable. The DEV_RES table should contain a couple of hundred entries only (maybe up above the thousand mark and that depends on the number of BS´s you have).