hi,
i have try to make some Sample to "test" Speed
using a 32 Bit Apps
ADO
Records = 59780 Time = 41.74 1432.23 Rec/Sec
XLSwriter
Records = 59780 Time = 8.20+ 7285.80 Rec/Sec
so XLSwriter is 500 % faster
---
now use XLSwriter with > 350000 Record using 32 Bit App ...
32 Bit Aoo using XLSwriter "crash" > 109000 Record while "memory exhaust"
32 Bit App using ADO does create a 20 MB *.XLSB with all 351287 Record
ADO
Records = 351287 Time = 288.54 1217.47 Rec/Sec
XLSwriter
RECNO() = 109571 MEMORY( 3 ) = 31044 // have set Limit at 32 Kb
it is just before available Memory "crash" so leave loop
i "think" it have to do that ADO "read/write" while XLSwriter "read" all to RAM before "write"
when "break" ADO there is a *.XLSB but nothing when XLSwriter "crash"
---
using a 64 Bit Apps
ADO
it is funny that my 64 Bit MSVC App work slower that 32 Bit BCC7 App ?
cIn = "records in dbf: 351287"
cIn = "imported recs: 351287"
cIn = "Std 00:06:13"
cIn = "Rec/Sec 940.51"
XLSwriter
nReccount = 351287 nRecLast = 351288 % = 100 nTime = 71.06 4943.40 Rec/Sec
nOEM = 107712 nANSI = 17642 nELSE = 5821450
this was 32 Bit App
nReccount = 351287 nRecLast = 109571 % = 31 nTime = 50.96 2150.14 Rec/Sec
nOEM = 39715 nANSI = 4747 nELSE = 1811139
btw. when RAM decrease also APP Speed decrease using 32 Bit App
so also XLSwriter 64 Bit is 500 % faster
---
Epilogue :
Benefit ADO : work under 32 Bit App. no "Umlaute" Problem using OEM DBF
Limitation : Speed like ActiveX
Benefit XLSwriter : SPEED
Limitation : need UFT8 else it "crash"
not sure : XLSwriter 32 Bit App get "slower" when use many Times include "edit"/Recompile
from 2150.14 Rec/Sec it goes < 2000 Rec/Sec ... after re-
boot it start at 2300 Rec/Sec