You can use SQL to perform a query that tells you the length of a queue.
To find the length of a deferred indexing queue
1 | Open and log in to SQL Advantage. |
2 | Enter this command: |
select x.mq_index, x.queue, entries = count (*)
from mq_index x, mq_index_queue q
where x.mq_index = q.mq_index
group by x.mq_index, x.queue
SQL Advantage displays the result of the query.
Here is a sample result list from this query:
mq_index |
queue |
entries |
bibkw |
1 |
170 |
auth |
1 |
179 |
unifath |
1 |
106 |
subject |
1 |
80 |
In this example, there are 170 bib records saved that may have a bibkw index to update.
© 1998-2017 Sirsi Corporation