Performace Problem After Upgrade

[egormsen]

We upgraded to 7.0.4 this weekend and everything went great until we starting having performance problems this evening.

We have a folder off the main store that contains a chat room for people that have purchased online classes from our store. This has been working great for the past 18 months, until we had tonights performance problem.

It appears that the problem is realted to AC updating the ac_user table for each user every time some page is refreshed in that folder.

I first disabled page tracking and put a line the ablecommerce.config file the app_data folder to tell it do ignor that folder. While now not logging pageviews is it still updating the ac_users table - appears to be only updating the lastactivitydate. This is resulting in hundreds of "update ac_users" statements to be executed each second when we get a large number of users (100) in the classes.

Is there anyway that I can have AC not log activity on that folder - is it not necessary and provides not value.

Thanks,

Eldon

[mazhar]

Well there is no configuration that can disable this feature. This is being done in back end code so you can disable it without a change in source code. Secondly disabling it can cause some other features to stop working for example one thing I can think of is the "Who is online" module. Similarly there could be other potential features that could be affected with this change.

[egormsen]

What changed in this release related to tracking user actions? As a mentioned this was working great until we installed 7.0.4 this weekend - it seems like either some queries where made less effecient, or the number of times that the sql statements are called has increased by a large amount. Seems like some type of ineffiencies where introduced in the release.