Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-02 Thread Kevin King
-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

[U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma
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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Israel, John R.
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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread David L. Wasylenko
, 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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Davis
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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma
. 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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wols Lists
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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wjhonson
: 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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wjhonson
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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread David L. Wasylenko
: 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

2012-06-01 Thread Dave Laansma
: 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