Thanks for your answer.

You absolutly right.

You cant directly save the request in a variable but you can create a classmethod that execute the query and return the resultset. And then you can save this return in a variable.

Thanks a lot Dmitry that save 10s of page load :)

Exactly that :)

Thanks a lot.

Strange but with this function the perfermance are really bad :(

0.04s without and 13s with it ...

I tried with an other table with just 2 properties ( but more than 1million records too) and that's the same problem.

see:

http://imgbox.com/Df2WlAPo
http://imgbox.com/tEFMR5V8

Thanks a lot Bernd,

Adding the wildcard in the Handler Mappings was the solution.

Great :)

Thanks,

Have a good day

Sébastien

Hello,

Thanks a lot a didnt see this section.

Sébastien

Hello & thank you for your quick response.

Indeed, there was a Source Controle Class enabled, now disabled to test if it's really the problem. The thing is it has been enabled for quite a moment (several months), why would this sort of problem happen now ?

Unfortunately the Source Control Class wasn't the problem, it's still happening.

I cas use Portal's License Usage pages, here's a screenshot of 'Usage by User' :

As you can see, they are all CSP type, and are '/csp/sys/' application

Hello Dimitry,

You right I can access some response header in the OnPreHTTP with GetHeader.

But apparently i cant access to all my header variable, in my case I add a custom variable named SSLDN (server side) but I cant see it in %response ...

Thanks

Sébastien

Hi Daniel,

Thank you for your reply.

The large amount of cached queries is a very good idee, indeed we found some table with millions queries cached ... 

We're going to clean up the queries, optimize the code queries and see if this solves the problem.

Thank you

Sébastien

Thank you for your reply.

The mapping is actually not used on this namespace.

Thank you

Sébastien

Thank you for your reply.

Yes the source control is enabled but also on the other namespace without problems.

Thank you

Sébastien

Hello,

Already tried and same result :(

Yes it work but I want to keep a main dispatcher with only the base route:

<Map Prefix="/v([0-9]{1,2})/news"    Forward="API.Dispatch.news"/>

I tried:

In main dispatcher:
<Routes>
   <Map Prefix="/v1/news"    Forward="API.Dispatch.news"/>
</Routes>

And in the sub-dispatcher:
<Routes>
   <Route Url="/:id"                        Method="GET"  Call="NewsGetItem"/>
</Routes>
And so with classmethod:
ClassMethod NewsGetItem(id As %Integer) As %Status
{
    w id
    Quit $$$OK
}
But still 404