Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-02 Thread Kevin King
58 1482 > d...@pickpro.com > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-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

Re: [U2] Monthly Multivalue Inserts and Speed

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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wjhonson
Jun 1, 2012 10:09 am Subject: Re: [U2] Monthly Multivalue Inserts and Speed FILE.STAT results: MOD OV HTY ITEMS BYTES MNI/G MXI/G MNB/I MXB/I 7801 0 64 731825 2197829057 02719 14300 ---- --- 7801 731825 2197829057 Sincerely, avid Laansma T Mana

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma
st Subject: 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 [mailt

Re: [U2] Monthly Multivalue Inserts and Speed

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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wjhonson
shifting it off. At any rate, the files can be *walked* you know, you don't have to guess, you can actually see them in action by byte-parsing them on the fly. -Original Message- From: Wols Lists To: u2-users Sent: Fri, Jun 1, 2012 8:30 am Subject: Re: [U2] Monthly Multival

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wjhonson
---Original Message- From: Dave Laansma To: U2-Users Sent: 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 sim

Re: [U2] Monthly Multivalue Inserts and Speed

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

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma
Of David L. 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 s

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 David L. Wasylenko
ma Sent: Friday, 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

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 with

[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 dependen