User bio
404 bio not found
Member since May 17, 2016
Posts:
Replies:
I urge folks to avoid ^%GSIZE with show details = yes unless there is an urgent need for recent size info. If you're going to read the whole database, I'd suggest an Integrity Check instead. It provides the same information but also verifies integrity.
I use the following to get the full query.
SELECT Location, RuntimeLocation, Statement->Statement FROM INFORMATION_SCHEMA.STATEMENT_LOCATIONS WHERE Location = ? OR RunTimeLocation = ?
Certifications & Credly badges:




Global Masters badges:


Followers:
Following:
Chad has not followed anybody yet.
I worked with a customer last year that had about 500,000 messages per day. It took an hour to collect one day of data and 8.5 hours to process it on a dedicated m6i.large. They found 12,000 discrepancies but used the SkipList feature and some SQL queries to sift through the results.
E.g.