Alex Rufon wrote:
6. The slowest part of the system is not during J calculation but during the time J calls ADO to retrieve and write to MS-SQL. We've proven this with the new version where J does not connect directly to the DB and instead expect array input and output.
I'm not familiar with ADODB, does ADODB has the capacity to do column binding (not sure ado use this term) ? And IMO the bottleneck is not J interfacing sql database, but wd oleautomaion interfacing com or dotnet is the real bottleneck. My experience is that J can insert 10000 rows into sql database within a few seconds.
---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
