I'm making a scheduler.. i have a table of scheduled and scheduleable
hours for multiple users which needs to be turned into a view (with
schedule type as there are 4 different types) of 7 days of those
scheduled and scheduleable hours for multiple users..
right now i've a loop which iterates over every hour and tests it
against all the returned scheduleable and scheduled hours for those 7
it's really slow.. the loop that figures out the schedule type runs like
1000 times and just obliterates my processor locally while it's running.
anyone have any suggestion of how to speed things up? i've been
thinking about it but can't seem to come to a speedier conclusion.