>Make sure you've indexes on all fields used in JOINs. Quick loock revealed that you don't have indexes in the Termcourse table for following joins

...
>   ON  Termcourse.roomid = Roomslist.roomid ;
>    INNER JOIN smagic!schedulehours ;
>   ON  Termcourse.hourid = Schedulehours.hourid ;
>    INNER JOIN smagic!teacherlist ;
>   ON  Termcourse.teacherid = Teacherlist.teacherid;
>...
>

I added those, but it's still not so good. I think what's causing it is

>>Joining table schedulehours and table termcourse (Cartesian product)
>>Joining intermediate result and table roomslist (Cartesian product)
>>Joining intermediate result and table programlist (Cartesian product)
>>Joining intermediate result and table teacherlist (Cartesian product)
>>Joining intermediate result and table courses (Cartesian product)
>>Joining intermediate result and table courselist (Cartesian product)
>>Joining intermediate result and table enroll (Cartesian product)
>>Joining intermediate result and table attendance (Cartesian product)
>>Joining intermediate result and table person (Cartesian product)

these Cartesian joins. The WHERE Termcourse.crsschedid = (?vp_crsschedid) will filter it down to the 29 record result, so how do I make it evaluate the where clause early?