[Jprogramming] ole array argument

bill lam bbill.lam at gmail.com
Mon Feb 26 14:38:00 HKT 2007


Alex Rufon wrote:
> Um. Do we have more information online about this?
> 
> You see, since I use the JEXEServer.SetB interface exclusively, I have
> been forced to convert my data to string. 
> 
> As an example, here is my C# code which takes a .NET DataTable and
> creates a CSV string delimited by (16{a.) and (17{a.) for columns and
> rows using the StringBuilder class. As you can imagine, when converting
> 49,000 rows of data ... there is a very noticeable delay before the data
> read from MS-SQL is actually given to the J Session.
> 

Um, I do not have experience with JEXEServer, but you may download the new 
ooo.ijs to see if anything useful.  However I guess that even if it is possible 
to pass data without converting to string, the overhead of calling idispatch is 
still very large if it is called repeatedly for 49000 times.  You have to 
minimise this traffic too.

Any
-- 
regards,
bill


More information about the Programming mailing list