I have written a search query and when I run this in the Sql Management Studio this query runs fast. I het F5 and i see my results immediatly.
But when I execute the same query when I am running Umbraco, a timeout occurs. It takes about 1-2 minuten before my query completes. As soon as I kill the Umbraco application, the query is fast again.
So my question is, how can I prevent that my query is executed so slow?
Is use var results = DatabaseContext.Database.Fetch<SearchResult>(query).ToArray(); to execute my query. The query variable contains the query that is fast when I run this query in Sql Management Studio, but is terrible slow when I am execute it this way.
Query becomes slow when using Umbraco
I have written a search query and when I run this in the Sql Management Studio this query runs fast. I het F5 and i see my results immediatly.
But when I execute the same query when I am running Umbraco, a timeout occurs. It takes about 1-2 minuten before my query completes. As soon as I kill the Umbraco application, the query is fast again.
So my question is, how can I prevent that my query is executed so slow?
Is use
var results = DatabaseContext.Database.Fetch<SearchResult>(query).ToArray();to execute my query. Thequeryvariable contains the query that is fast when I run this query in Sql Management Studio, but is terrible slow when I am execute it this way.is working on a reply...