• I don't want to say that sql Turbo is a bad product, we are very happy with the speed, but found some issues with it:

    - Memory management issues, as with everything using sp_OA... it runs in the "executable code" memory zone and not the "Memory pool". That forced us to buy more memory because Executable code memory zone has a fixed size (that could be set through a startup parameter) and increasing it reduced the buffer available for the "standard" queries with a negative impact on performances...

    - Security issues (I like to remove sp_OA... from all my production servers)

    - Troubles mixing standard sql indexes and Sql Turbo indexes...

    - This forced us to created a Sql Turbo index on a bit column, resulting in "strange" behaviour.

    Best Regards

    Douglas

     

    p.s. sorry for the bad English it's not my mother tongue