-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
If you are using dynamic arrays, switch to dimensioned arrays. You will be
amazed at the performance increase.
John
-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 10:30
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, but over the long-term,
avoids sizing issues that are the #1 reason for bad performance.
Can you perform an
You are probably better off sizing the file correctly, or sizing it to the size
it will be at the end of the year, than trying to do what you are proposing.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave
.
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
On 01/06/12 15:33, Israel, John R. wrote:
If you are using dynamic arrays, switch to dimensioned arrays. You will be
amazed at the performance increase.
John
And going by what you've said, what I would do - MAKE SURE THIS IS
DOCUMENTED IN THE CODE - is undersize the array with a DIM
All numbers are stored in Pick datafiles as strings.
There is no vendor, never has been, who has stored the numbers in datafiles as
anything other than numeric strings.
Now if you were talking about the runtime engine and how it stores variables
that's another fish.
I would like to think
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
10 matches
Mail list logo