Resources Slow to Load

Dan,

Have you checked how long the SQL resource loading code takes on the server side?

Loading 60 resources should be no problem. You take a look at the following demo for reference:

http://www.daypilot.org/demo/Scheduler/RowProgressiveRendering.aspx

It displayes 1000 resources. It's not super-fast but it doesn't take more than about 7 seconds to receive the response from the server. The client-side rendering takes about 300 ms.

Thanks for your reply Dan!

It is an older version of Daypilot Pro, 7.x

I'm not sure if that could cause it?

If I run the sql view on the server side, in sql management studio it opens immediately

How do i check how long the SQL resource loading takes?

The data for the resources is just a small SQL table, I'm not sure the resources load slow.

It is slow even when I dont bind events

Thanks!

> It is an older version of Daypilot Pro, 7.x
> I'm not sure if that could cause it?

This shouldn't be a problem.

> The data for the resources is just a small SQL table, I'm not sure the resources load slow.

If it's a small table than it's most likely not the problem. It looks like you run 1 + 6 queries to load the resources.

Do you run SQL queries in BeforeCellRender? That would have much greater impact (even fast queries).

We run the queries on page load like in the kb.

If I follow the Static configuration (.aspx) on this page - https://doc.daypilot.org/scheduler/resource-loading/

And load 100 resources/ children it loads fine!

Thanks for any advice