Hi Am am following this kb from here
http://kb.daypilot.org/10298/how-to-load-scheduler-resource-tree-from-a-database-sql-server/
It displays the resources and their children great.
The only problem is that loading 6 resources with 10 children each, makes the page load in 15 seconds
If I change it to just load 2 Resources with 10 children each it olnly takes 5 seconds
Thanks for any advice!
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
This question is more than 1 month old and has been closed. Please create a new question if you have anything to add.
DayPilot