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
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
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
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
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.
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
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:
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:
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:
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
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
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
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 suggest
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.nethttp://www.fwic.net/
LinkedIn
19 matches
Mail list logo
