• bullo (4/4/2012)


    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

    First Access <> SQL Server (any edition).

    Second, what database engine are you running in MySQL?

    You are basically trying to compare apples <> oranges <> pears. They all work differently and have different strengths and weaknesses. Making 1000 separate calls to MS SQL Server instead of one well written set-based query is going to behave differently than the same calls to Access or MySQL.