hi Guys,
I have a query which runs for 20 sec in Query Analyzer but from API it takes more than 5 minutes. I would say it was in the application but I monitored it and I see it is neither the application code nor the connection time which slows it down - it just runs so slow when started from application!
The strange thing is that some week ago it was equally fast from api and from Query Analyzer.
Had anyone got problem like this? Or any ideas?
I have a query which runs for 20 sec in Query Analyzer but from API it takes more than 5 minutes. I would say it was in the application but I monitored it and I see it is neither the application code nor the connection time which slows it down - it just runs so slow when started from application!
The strange thing is that some week ago it was equally fast from api and from Query Analyzer.
Had anyone got problem like this? Or any ideas?