Kent,
My speed test results:
Overall: 16.6 seconds
This breaks down approximately as follows
Randomiser calls: 0.15
Conversion of doubles to strings: 2.38
Concatenation of strings: 2.15
which leaves about 12 seconds for sqlite processing
my test rig:
tSub.Start
a.Begin
string s
string d1="123456789",d2="123456789",d3="123456789"
'double d1,d2,d3
for x = 1 to 1000000
'd1=RandD(rx,ry,rz)
'd2=RandD(rx,ry,rz)
'd3=RandD(rx,ry,rz)
s= "insert into Enterprise values ( "RandD( rx, ry, rz )","RandD( rx, ry, rz )","RandD( rx, ry, rz )" );" crlf
'a.put( "insert into Enterprise values ( "RandD( rx, ry, rz )","RandD( rx, ry, rz )","RandD( rx, ry, rz )" );" crlf )
'a.put( "insert into Enterprise values ( "d1","d2","d3" );" crlf )
next
a.End
tSub.Stop