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