KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: How to Generate Large Test Data File
PRODUCT: 4D | VERSION: 20 R | PLATFORM: Mac & Win
Published On: November 18, 2024

Somtimes large data files are needed in order to test database performance. One convenient way to generate large data files is by using BLOBs. The following code will generate a data file roughly the size of $n GBs.

var $b : Blob

$n:=20

$gb:=1073741823

For ($i; 1; $n)
   $e:=ds.Table.new()
   SET BLOB SIZE($b; $gb; 0x00FF)
   $e.blob:=$b
   $e.save()
End for


* Be careful not to set n so large that the machine running the test does runs out of disk space

Here is the definition of Table: