Thanks Don. I understand about being too busy to respond, been having
the same problem.
You answered my main question, which was if you were able to get the
ReadList method to work. I tried exactly what you have there (except in
VB), but no success. When I step through the code in the debugger, I
get to the line that is the equivalent of your
uvTmp = uvsl.ReadList();
The debugger shows the list of id's for uvsl.ReadList but when I execute
the step to assign it to uvTmp, uvTmp is empty, and uvsl.ReadList is
empty also!. No error is thrown. Not sure what's going on there.
I haven't switched over to UO.Net yet though. So I think I'll drop this
until I start using UO.Net.
Thanks again
Victor
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey
Sent: Saturday, December 04, 2004 9:02 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Uniobjects.NET speed/performance
Sorry so late, it's been very busy here and I've turned off u2 list
access at work in order to cope... Here's a snippet of code form the
very project that is currently taking up all my time. The array logic
was stolen right out of the .net developers guide...
............... This is just a section of code, this won't compile as
is...............
string [] lRecIDArray ;
ArrayList lRecIDList = new ArrayList(20000);
StringBuilder lStrValue = new StringBuilder();
UniDynArray uvTmp =
uSession.CreateUniDynArray();
// select a file, here I'm just getting
everything
uvsl.Select(uvfVENDOR);
// read the whole list into a unidynarray, I
happen
to know this file is not very big so it's ok.
uvTmp = uvsl.ReadList();
// create array of Record IDs
for(int Index = 0; Index < uvTmp.Dcount();
Index++)
{
string s =
uvTmp.Extract(Index).ToString();
if (s.Length > 0){
lRecIDList.Add(s);
}
}
// this is the part obtained from the manual.
lRecIDArray = new string[lRecIDList.Count];
lRecIDList.CopyTo(0,lRecIDArray,0,lRecIDList.Count);
// read records using array of record ids
// this part is fast, get all the stuff you want
right now
UniDataSet lSet =
uvfVENDOR.ReadRecords(lRecIDArray);
int iCnt = 0;
char uvVM = Convert.ToChar(253);
char SPACE = Convert.ToChar(32);
foreach (UniRecord uvVendor in lSet) {
uvTmp = uvVendor.Record;
// extract and process the data
string tmp =
uvTmp.Extract(1).ToString();
// the rest is snipped...
endendend
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Victor St Clair
Sent: Monday, November 29, 2004 1:28 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] Uniobjects.NET speed/performance
I've had the same experience, using a select loop in a list runs very
slowly, and was planning to try this same approach. I tried to use
ReadList method of the Slist object as documented in the UniObjects
manual, but haven't gotten it to work yet. Did you use the ReadList or
did you fill the array by repeating listobject.Next()?
I'm still on UniObject 6, working with UniData 6. If I just do a
listobject.Select(fileobject) then it processes fast enough. But if I
execute a command to create a select list and then loop through it, the
performance gets progressively worse as the record count increases.
I'd appreciate any example you might be able share.
Thanks
Victor St. Clair
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Donald Kibbey
Sent: Thursday, November 04, 2004 4:11 AM
To: [EMAIL PROTECTED]
Subject: Re: [U2] Uniobjects.NET speed/performance
I found that using a select list within a loop was cause for a long
nap... I fixed that by reading the entire list into an array and then
looping through the array. I've read on this list that there is an
updated uniobjects.dll available, but my VAR was not able to locate
it?!?
I really don't understand why IBM does not just post the developers
tools as a public download. You really can't do much with them unless
you already have a licensed database so why the hassle?
Don Kibbey
Financial Systems Manager
Finnegan, Henderson, Farabow, Garrett & Dunner LLP
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
