![]() ![]() During dequeue, a batch of rows are selected, updated and then returned for processing.Thus the tables keep getting slower and slower every day and eventually queries start timing out until you take a downtime and rebuild the indexes. You can’t rebuild index on the Queue table because it contains text and/or binary fields. The Queue table needs to store serialized objects in XML or binary form, which becomes a storage and index rebuild challenge. ![]() Sometimes Orders have higher priority and need to be processed regardless of when they are queued.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |