Also compare it with filling out those arrays directly from DataReader as opposed to DataTable.
--- Oleg Kobchenko <[EMAIL PROTECTED]> wrote: > I liked you previous email about abandoning > the complaxities and going back to simple > natural things. > > So if you apply the same approach to passing > array in and out of J, what is the simplest > and efficient form(s) to minimize boxing and handle > heterogenity passing a table? > > The single call string approach is not bad. > But still it's worth comparing it with the > optimized one. > > > --- Alex Rufon <[EMAIL PROTECTED]> wrote: > > > Oh thanks. I'll look into ooo.ijs. > > > > I guess a lot of us knows that OLE/COM data transfer is easier when the > > data is coming in from the J Session into .NET or the calling > > application. The rub lies on putting the data into the session. Like in > > my case, I may be reading an SQL table that have heterogeneous data like > > a varchar, currency and date and time columns in one row. In my case, > > since I use the SetB() interface ... trying to give J a 2 dimensional > > array of text and numbers will throw a "domain error". > > > > I cant seem to wrap my brains around using the 3!:1 format from .NET so > > that J would be able to read it properly. I guess I'm really lazy. > > Hahahahahah. > > > > Which asks the question ... does anybody have code that will convert > > .NET arrays into the 3!:1 format? > > > > Is there a way where I can just populate a J variable with a .NET ARRAY > > variable without conversion first? (I just re-read this and my question > > is sooo n00b) > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of bill lam > > Sent: Monday, February 26, 2007 2:38 PM > > To: Programming forum > > Subject: Re: [Jprogramming] ole array argument > > > > 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 > > ---------------------------------------------------------------------- > > For information about J forums see http://www.jsoftware.com/forums.htm > > ---------------------------------------------------------------------- > > For information about J forums see http://www.jsoftware.com/forums.htm > > > > > > > ____________________________________________________________________________________ > TV dinner still cooling? > Check out "Tonight's Picks" on Yahoo! TV. > http://tv.yahoo.com/ > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ____________________________________________________________________________________ Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/features_spam.html ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
