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
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 AM
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 "ANALYZE.
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 Laans
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, blocksize = 16384
Split load = 10, Merge load = 5
Split/Merge type = KEYONLY
Sincerely,
David Laansma
IT Manage
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 A
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.
<>
-Original Mess
Oh PS on your other point, doing all the inserts at once isn't going to make
any difference.
Each time you change the length of ANY attribute in a record, the system picks
up the entire record, and rewrites it again at the end of its group.
Thus shifting everything else in the group forward. Th
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...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent:
FILE.STAT results:
MOD OV HTY ITEMS BYTES MNI/G MXI/G MNB/I MXB/I
67801 0 64 731825 2197829057 02719 14300
---- ---
67801 731825 2197829057
Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-2
The 3K size is only relevant when you are acting on the item in the runtime
engine.
When you write it back out, the relevant information is how many of its
*siblings* does it have to reshuffle about
That's why the number of bytes per group is important, because each write
reshuffles the group.
File size looks small.
Very generic sizing rules:
Pick a modulo of the smaller of these two numbers:
* The item count within the file (731,825)
* The total byte count divided by the group size (2,197,829,057 / 16,384
= 134,144)
Then find a prime number above that, or at least not di
I am sending a CSV file to excel, and would like to divide it into separate
worksheets. Is there a special value I can insert in the file which would
cause the following data to create a separate work sheet ?
Thanks,
Jim Koca
Cell Phone: 630.253.0007
Home Office: 630.629.5589
Email: jk...@comca
That would be nice.
I create separate CSV files and use macros to load each into a separate sheet.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jim Koca
Sent: Saturday, June 02, 2012 3:17 AM
To: u2-users@listserv
If you don't mind switching from csv to xml, you define worksheets that way.
Google excel and xml and worksheets
It's a lot more work, but it works
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
I use xml for a few of our fancier reports. My technique is to built the Excel
file the way I want it, save it as xls, then pick it apart. Again, it is a lot
of work, but they are beautiful. Multiple worksheets, colors, formulas, pane
freezing, etc. This might be the brute force method, but
Hi,
We'd like to find a digital scale that works like a USB-based HID keyboard
wedge style scanner that simply transmits the unit weight into the current
field when a button is pushed. For this application we'll be weighing small
parts under 10 to 15 lbs and also need metric output. From bri
Or save yourself the trouble http://www. remove this
nebula-rnd.com/products/xlite.htm - There isn't anything in the CSV
"standard" that would create a new sheet and I haven't run across anything
that Excel uses.
hth
Colin
-Original Message-
From: Israel, John R.
I use xml for a few of o
> From: Jim Koca
> I am sending a CSV file to excel, and would like to divide it into
> separate worksheets. Is there a special value I can insert in the
file
> which would cause the following data to create a separate work sheet
[AD]
As soon as your needs go beyond basic columns and rows I sugg
No idea about the scale but I use a small, generic serial to USB adaptor with
my laptop for a GPS device that has a serial interface . If I remember
correctly it cost about 20 bucks. So you could use one of those as a last
resort. The "serial" software works with it perfectly.
Stuart.
__
Does Rocket license Universe or Unidata for use in the cloud?
Robert Houben
IBM Certified Solution Advisor and Architect - Cloud Computing Architecture
Chief Technology Officer
FusionWare Integration Corp.
p: 604-777-4254 x158
f: 604-608-5544
http://www.fwic.net
LinkedIn
21 matches
Mail list logo