-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Friday, June 01, 2012 12:09 PM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed
FILE.STAT results:
MOD OV HTY ITEMS BYTES MNI/G MXI/G MNB/I MXB/I
67801 0 64 731825 2197829057 02719 14300
I have a file that is taking a very long time to update, seemingly
longer and longer each month. Here is briefly how the attributes are
organized, a relatively simple example:
Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
12-03 etc.
Attributes 2 through 30 are
AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Monthly Multivalue Inserts and Speed
I have a file that is taking a very long time to update, seemingly longer and
longer each month. Here is briefly how the attributes are organized, a
relatively simple example:
Attribute 1 is multivalued
, June 01, 2012 9:30 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Monthly Multivalue Inserts and Speed
I have a file that is taking a very long time to update, seemingly longer and
longer each month. Here is briefly how the attributes are organized, a
relatively simple example:
Attribute 1
Laansma
Sent: Friday, June 01, 2012 10:30 AM
To: U2-Users@listserver.u2ug.org
Subject: [U2] Monthly Multivalue Inserts and Speed
I have a file that is taking a very long time to update, seemingly
longer and longer each month. Here is briefly how the attributes are
organized, a relatively simple example
.
Wasylenko
Sent: Friday, June 01, 2012 10:32 AM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed
3k isn't large.
#1 thing to look at is file size.
Change the file-type to dynamic. It will not give the best performance
compared to monitoring file size of a static file type
Multivalue Inserts and Speed
I have a file that is taking a very long time to update, seemingly longer and
longer each month. Here is briefly how the attributes are organized, a
relatively simple example:
Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
12-03 etc
: Fri, Jun 1, 2012 7:30 am
Subject: [U2] Monthly Multivalue Inserts and Speed
I have a file that is taking a very long time to update, seemingly
onger and longer each month. Here is briefly how the attributes are
rganized, a relatively simple example:
Attribute 1 is multivalued with our G/L
Subject: Re: [U2] Monthly Multivalue Inserts and Speed
On 01/06/12 15:33, Israel, John R. wrote:
If you are using dynamic arrays, switch to dimensioned arrays. You will be
mazed at the performance increase.
John
nd going by what you've said, what I would do - MAKE SURE THIS IS
OCUMENTED
: Friday, June 01, 2012 9:41 AM
To: U2 Users List
Subject: Re: [U2] Monthly Multivalue Inserts and Speed
Results of the ANALYZE.FILE:
Dynamic File name = WHSE.STAT
Number of groups in file (modulo) = 67801
Minimum groups of file= 67801
Hash type = 0
: Re: [U2] Monthly Multivalue Inserts and Speed
What's the record count and total byte count?
... david ...
David L. Wasylenko
President, Pick Professionals, Inc
w) 314 558 1482
d...@pickpro.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun
11 matches
Mail list logo