David Mitchell wrote:
> I am using the MS Access driver Version 4.00.6304.00. The initial DB is
> empty. The script is saving the file names, sizes, time stamps and 3
> integer values for all the files on my hard drive. I make two calls to
> ddins, one with all directory paths and one with all file names. The
> directory path add worked fine, it has 4 columns, paths, time stamps and
> 2 integer values.
>
> sqlbulkoperations will hang with the standard character format ddins or
> the modified boxed format one. Both forms of ddins will work with the
> smaller MAXARRAYSIZE.
>
Thanks David, I can reproduce the bug. I must only tested with simplier cases
that it worked. To workaround ms access bug, it should restore the old value
MAXARRAYSIZE=: 65535
as a comparison for ms access,
ch=. ddcon_jdd_ 'dsn=jdb1'
ch ddsql~ 'create table table1(fname varchar(250),fsize long,fts timestamp,int1
long, int2 long, int3 long)'
ch ddsql~ 'delete from table1'
nr=.100000
da=. ((nr,250)$'abc');((nr,1)$i.nr);((nr,16)$'{d ''2006-07-28''}');((nr,1)$4 5
6);((nr,1)$7 8 9);((nr,1)$0 1 2)
ch ddins~ 'select fname,fsize,fts,int1,int2,int3 from table1';da
timing on my aged celeron 1.7 (MAXARRAYSIZE=: 65535)
100000 row 30 sec
1000000 rows 6 min
what's your timing?
--
regards,
bill
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
