Finding the Length of a Deferred Indexing Queue

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