M
marian.edu
Guest
Hey Jeff, not much of a dba but I guess if the record doesn’t fit in the previously allocated space it has to be moved around… a character is a variable size so it’s the perfect candidate when it comes of increasing the record size 
I suspect there might be some database settings that can help heal the pain there, or maybe you just move the blob field in another storage area? Else when table-scan is not available you might try to use a simple find/while available loop instead… find first table where pk no-error. if available table update pk. else leave. Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212
Continue reading...
I suspect there might be some database settings that can help heal the pain there, or maybe you just move the blob field in another storage area? Else when table-scan is not available you might try to use a simple find/while available loop instead… find first table where pk no-error. if available table update pk. else leave. Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212Continue reading...