using events 5.0.2 and dnn 4.9.1

I'm having issues with the speed of the event views.

When enabling "Tooltip", the time to load the module goes up 30+ seconds.

Without the Tooltip, both Month & Week views load in 6 or 7 seconds, which is still long, but more or less acceptable.

The list view still loads for 15 seconds.

When I filter out the data (list view settings, selected days) to return only 1 or 2 records, the module loads in 2 or 3 seconds. When about 10 records are returned in the grid, the loading takes 8 seconds, when 50 records are returned, it takes 15 seconds or something.

I know a bit of SQL, and I've caught the procedure call with SQL Profiler, "EventsGetByRange", and ran it on the DB seperately. However the results always run in 1 or 2 seconds max, so I don't think the database connection is the problem.

So I have 2 questions,;

- why does the "tooltip" function have such a great impact on the events module performance, and what can I do about it?

- why does list view load so slow for me?

If you need any more information, ... please, ask away

Thanks in advance,

kind regards,

Dieter

Thank you for your reply,

I've tried to create a simulation of the problem, and while investigating, I think there might be a problem with concurrent users.

Please try the following:

- to start with, a page without the events module:

http://revalidatieziekenhuis.keigrp.b... 

This page loads in 1 or 2 seconds (Of course, this might be different where you live)

When you load this page in internet explorer, and copy the URL over 20 tabs (ctrl-K for easy shortcut), and reload all tabs all at once, you can see they all load in the SAME 1-2 seconds.

- then try to load this page: (on the same dnn installation)

http://intranet.keigrp.be/tabid/409/l...

This page loads in about 3-5 seconds.

When you load this page in 20 tabs at the same time, you will see that instead of all the loading taking 3-5 seconds, they seem to be waiting for each other. The last page that loads probably took 50 seconds to load, instead of 5 seconds.

I understand that a single page load takes longer when another page is loading somewhere else, but I think it's more than that.

Maybe you could shed some light on this?

Thanks in advance,

Dieter

Thanks,

First, will this 5.0.4 release work for dnn 4.9 ?

And secondly, I saw something in the database while looking for a solution. I don't know much about asp.net, but I do know something about SQL, and I saw that the stored procedure "EventsGetByRange" is built up using a string variable.

One thing I remember from being a database administrator (years ago) is that it's never wise to build up complicated queries using varchar variables. Normally, when running a sql or stored procedure, sql server caches & optimizes the query plan according to the indeces and what sql server thinks is the fastest approach to get the result. Maybe this changed, but as far as I know this doesn't happen when you build up a query using a varchar string, then, sql server can't "analyze" the query.

I don't know if this tip will help, it might be worth looking into.

Thanks again.

Dieter