[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