The studio is very slow on a specific namespace

Studio, Caché

Hello, everyone,

I'm trying to find solutions to a problem that's becoming quite boring.
On only one namespace, the sudio is very slow.
The studio freezes completely for 5-10 seconds when I save or compile a class. Sometimes it also freezes for no apparent reason at a random time...
It stops when I change namespace...

Do you have any idea what that could be?

Thank you in advance

Answers

Sebastien,

I remember once customer had the same problem and it turned out that they had large amount of cached queries existent in that namespace.

Can you check and eventually delete them? 

Other than this, I can imagine some issues with source control if you have any, but this is just a guess.

HTH

Dan

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

Any special mappings in that namespace? Size ?

Try to export classes and routines from that namespace and import them in a new namespace, is it still slow in the new namespace?

Thank you for your reply.

The mapping is actually not used on this namespace.

Thank you

Sébastien

Maybe you have source control enabled in this namespace?

Thank you for your reply.

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

Thank you

Sébastien

We had a similar issue at a site and it turned out the routine index was corrupt, recompiling all routines solved this.