bill lam wrote:
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?
Hi Bill,
I tried your test on two systems: A Dell laptop with 1400 MHz Pentium M CPU, 1
Gig memory and Hitachi 40G drive; A home built with 2191 MHz AMD CPU, 1.5 Gig
memory and Maxtor 80G SATA drive.
Laptop:
1e5 rows: 5.5 sec
1e6 rows: 74-171 sec
Desktop:
1e5 rows: 4-5 sec
1e6 rows: 95-109 sec
--
David Mitchell
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
