Hi there,
I really need some help here.
I'm developing an application in wich people can be planned on jobs.
I need to display a diagram in wich all people are displayed in segments of
30 minutes.
Those segments show if a person is planned at that time or not.
My problem is that my way of querying is very slow with many people
Let say we have.
100 persons
I want to see a diagram from 7 to 7 hours in segments of 30 minutes.. so 12
hours*2=24 segments
thus for 1 person i need 24 queries to find out if that person is free or
busy at a timesegment
For all 100 persons i need 24*100=2400 queries.
Let's say three people are accessing this diagram at the same time. The SQL
server has to execute 2400*3=7200 queries.
I'm using queries like
SELECT persid FROM planning WHERE persid='name' AND starttime <= '10:00' AND
endtime > '10:30'
Is there a better way to query the database to find out if somebody is
planned at a given timesegment?