On 5/21/21 12:26 PM, Phil Stracchino wrote: > > What is the maximum possible size of File.LStat? That is another good > candidate to become a VARBINARY.
The largest File.LStat value I have is 71 characters. +---------------+--------------+ | length(LStat) | count(LStat) | +---------------+--------------+ | 71 | 118 | | 70 | 2707 | | 69 | 5307 | | 68 | 66928 | | 67 | 74186 | | 66 | 396988 | | 65 | 775913 | | 64 | 1761165 | | 63 | 6648470 | | 62 | 1489408 | | 61 | 14953604 | | 60 | 3746386 | | 59 | 11357239 | | 58 | 16665912 | | 57 | 13653005 | | 56 | 12194937 | | 55 | 5050784 | | 54 | 702068 | | 53 | 134690 | | 52 | 27701 | | 51 | 17234 | | 50 | 770 | | 49 | 172 | +---------------+--------------+ I'm going to say VARBINARY(96) seems pretty safe here. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
