Thank you for your reply.

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

Thank you

Sébastien

Thank you for your reply.

The mapping is actually not used on this namespace.

Thank you

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

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

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 & 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 ?

Hello,

Thanks a lot a didnt see this section.

Sébastien

Thanks a lot Bernd,

Adding the wildcard in the Handler Mappings was the solution.

Great :)

Thanks,

Have a good day

Sébastien

Hi Bernd,

Yes /csp/samples/docserver is enabled in web application and work on the ser-app-db server. But is not working on the ser-app-w server.

I use IIS, i'm not sur to understand where do you want I use the wildcard ?

Thanks,

Sébastien

Hello Robert,

Yes the gateway on ser-app-w is configured to access server ser-app-db.

It works for the cps and cls files, example:

http://ser-app-db/csp/samples/test.csp --> http://ser-app-w/csp/samples/test.csp

http://ser-app-db/csp/samples/test.cls --> http://ser-app-w/csp/samples/test.cls

But it's not working with a web application link like:

http://ser-app-db/csp/samples/docserver/request --> http://ser-app-w/csp/samples/docserver/request

Thanks,

Sébastien

Hello Robert,

Thank you very much for your fast and really helpfull answer.

My problem is fixed and my day is saved :)

Have a good day.

Sébastien

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

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

0.04s without and 13s with it ...

Exactly that :)

Thanks a lot.

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 :)