Long Waiting Time For Catalog Query

The 1C:Enterprise developers forum

Pages: 1

Selim	#1 People who like this: 0 Yes / 0 No Dec 02, 2024 10:23 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	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?

Aleksandr Biryukov	#2 People who like this: 0 Yes / 0 No Dec 03, 2024 08:47 AM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	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.

Selim	#3 People who like this: 0 Yes / 0 No Dec 03, 2024 08:19 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	hg

Aleksandr Biryukov	#4 People who like this: 0 Yes / 0 No Dec 04, 2024 11:45 AM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	I'm waiting for your querie's text

Selim	#5 People who like this: 0 Yes / 0 No Dec 04, 2024 07:10 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	When I write the query, it gives access denied and I cannot write for a while.

Selim	#6 People who like this: 0 Yes / 0 No Dec 04, 2024 07:11 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	It is very simple query from Catalog.Leads

Aleksandr Biryukov	#7 People who like this: 0 Yes / 0 No Dec 05, 2024 09:07 AM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	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?

Selim	#8 People who like this: 0 Yes / 0 No Dec 05, 2024 10:57 AM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	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?

Aleksandr Biryukov	#9 People who like this: 0 Yes / 0 No Dec 05, 2024 11:33 AM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	Does the user you are working under have read permissions to this Catalog? Have you tried querying this Catalog under a different user?

Aleksandr Biryukov	#10 People who like this: 0 Yes / 0 No Dec 05, 2024 01:32 PM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	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! Attached Files Download 1.png (10.59 KB) Download 2.png (9.27 KB)

Selim	#11 People who like this: 0 Yes / 0 No Dec 05, 2024 04:27 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	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

Selim	#12 People who like this: 0 Yes / 0 No Dec 05, 2024 04:28 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	Repairing it won't cause data loss, right ?

Aleksandr Biryukov	#13 People who like this: 0 Yes / 0 No Dec 05, 2024 06:29 PM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	No, it won't. It fixes the broken structure. But - before this procedure, be sure to make a backup!

Selim	#14 People who like this: 0 Yes / 0 No Dec 06, 2024 12:46 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	Thank you so much for your help brother.

Selim	#15 People who like this: 0 Yes / 0 No Dec 08, 2024 12:16 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	We repeared it. but it didn't work, do you have any other solution?

Aleksandr Biryukov	#16 People who like this: 0 Yes / 0 No Dec 09, 2024 06:38 AM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	Could you give me a dump of your program?

Selim	#17 People who like this: 0 Yes / 0 No Dec 09, 2024 08:10 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	How can i download the catalog, I didn't see an option

Aleksandr Biryukov	#18 People who like this: 0 Yes / 0 No Dec 10, 2024 11:28 AM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	Send me .dt file please. Do you know how to make it?

Selim	#19 People who like this: 0 Yes / 0 No Dec 10, 2024 08:49 PM
Active user Rating: 2 Joined: Sep 27, 2023 Company:	Hi brother, the company I work for did not allow me to share the dt file

Aleksandr Biryukov	#20 People who like this: 0 Yes / 0 No Dec 11, 2024 05:51 AM
Administrator Rating: 29 Joined: Oct 3, 2019 Company:	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.

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)

/* --- ФИКС ЗАГОЛОВКОВ ДОКУМЕНТАЦИИ (BRUTE FORCE) --- */ /* Цепляемся за все возможные контейнеры Битрикса */ .content h1, #content h1, .workarea h1, .content h2, #content h2, .workarea h2, .content h3, #content h3, .workarea h3, .content h4, #content h4, .workarea h4, .content h5, #content h5, .workarea h5, .content h6, #content h6, .workarea h6 { display: block !important; font-weight: 700 !important; color: #222 !important; text-transform: none !important; margin-top: 1.5em !important; margin-bottom: 0.5em !important; line-height: 1.2 !important; } /* Явно задаем размеры, чтобы перекрыть "font-size: 100%" */ .content h1, #content h1 { font-size: 28px !important; } .content h2, #content h2 { font-size: 24px !important; } .content h3, #content h3 { font-size: 22px !important; } .content h4, #content h4 { font-size: 20px !important; } .content h5, #content h5 { font-size: 18px !important; } /* Ваш случай (5 решеток) */ .content h6, #content h6 { font-size: 16px !important; } /* Если Битрикс или редактор засунули внутрь h5 тег span или font */ .content h5 *, #content h5 *, .workarea h5 * { font-size: inherit !important; color: inherit !important; font-weight: inherit !important; } /* --- СТИЛИЗАЦИЯ ТЕКСТА (Markdown Style) --- */ /* Ссылки в тексте делаем более заметными */ .content a:not([class]) { color: #005aa0; text-decoration: none; border-bottom: 1px solid rgba(0, 90, 160, 0.2); } .content a:not([class]):hover { border-bottom-color: #005aa0; } /* Списки (чтобы не прилипали) */ .content ul, .content ol { margin-bottom: 15px !important; padding-left: 20px !important; } .content li { margin-bottom: 5px !important; }

Download brochures