Not at all true. The performance penalty is less, but still measurable.

To fix a table with orphaned blobs, export the data, truncate the table, and 
reimport. Nothing to really worry about, except that you can't do a simple 
compact without erroring out.

> On Jul 29, 2018, at 4:26 PM, JOHN BAUGHMAN via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Note: Solid State Disk (SSD) drives do not face this challenge, so there is 
> actually no need to compact the data file on an SSD. In fact we recommend NOT 
> compacting the data file on an SSD because it contributes to drive wear. For 
> more information see Technical Note 10-09, SSDs and 4D v11 SQL.

**********************************************************************
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to