this is all for a SINGLE CLASS DAY.

the plus second is to find overlapping/close classes. i have to make a drawing to came up with that logic. the overlapping could be any class where any time from start to end overlaps this class start to end.

Anyway. Im in the process of re writing this page with ONE HUGE query with sub queries that show availability ,vacations, overlapping classes.

BUT it is still a MISTERY why on mysql or access, if I make 250 times (one per active coach) this:

query1 ->run query1. query2 ->run query2. query3->run query3.

it runs VERY fast , but runs SUPER slow on sql server. I cannot understand it. i made every latency test.

Probably something to do with SQLEXpress, but I dont think so.

my page is not optimal? IT is not. But this is independent.2 other db engines run it fine.

Regards,

Danny