Forum

Hello experts,

 Although there are 9 thousand records in the catalog, the data returns very late, what can we do,
 is there an option such as indexing or repair?

Hello Selim!

9 thousand - it is a very small value, with such a amount of data the query should work instantly!

Let's try to figure it out and find the reason for the slowdown.

First, show me please your query that works slowly.

hg

I'm waiting for your querie's text

When I write the query, it gives access denied and I cannot write for a while.

It is very simple query
from Catalog.Leads

Hmm... Does this problem occur when reading data only from this Catalog? When you make a query to another Object of programm - the query is also slow?

No Sir, there is no problem in other sections at the moment,
 only this catalog has problems, is
 there a feature like catalog repair, how can we repair it?

Does the user you are working under have read permissions to this Catalog?
Have you tried querying this Catalog under a different user?

There is also a utility for restoring the integrity of database tables. It can be launched directly from the Designer - see screenshots.

But before using this utility, be sure to make a backup!

Does the user you are working under have read permissions to this Catalog?
Have you tried querying this Catalog under a different user?


I have admin rights, other users reported the problem to me

Repairing it won't cause data loss, right ?

No, it won't. It fixes the broken structure.

But - before this procedure, be sure to make a backup!

Thank you so much for your help brother.

We repeared it. but it didn't work,
  do you have any other solution?

Could you give me a dump of your program?

How can i download the catalog, I didn't see an option

Send me .dt file please. Do you know how to make it?

Hi brother, the company I work for did not allow me to share the dt file

Ok, I understand, this is a normal requirement...

Try this: dump all the data into a .dt file, then load the data back from that file.