Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-02 Thread Kevin King 
Certainly the dimensioned array over dynamic would be beneficial in this
situation whenever possible.  Unfortunately, this only applies to your
custom code Dave, as the SB+ stuff and the stuff written by Prelude is
going to continue using the dynamic array access.  In your custom code, you
might be able to eek out some gains by separating the multivalued fields
you're using out to single attributes, update the single attributes, and
then replace the attributes in the record from the single attribute
variables.

Whether the file is dynamic or static will certainly play a part, with
dynamic files almost always performing worse than static hashed files.  In
my opinion [flame suit on] the only reason to use dynamic files in Unidata
is to breach the 2G limit.  There is no appreciable performance reason for
using dynamic files, unless of course you simply want the application to
perform worse than it would with a static hashed file.  Especially with
split load at 10% - you're going to split the group when it's 10% full of
keys.  That said, I can't really think of anything better except to not use
a dynamic file.

-K

On Fri, Jun 1, 2012 at 12:47 PM, David L. Wasylenko  wrote:

> 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 divisible by 2, 3, 5,
> 7...
>
> I get 134,147 for a reasonable modulo.
> The current mod is 67,907  which is about half the calculated modulo.
>
> 50% of your data is in hash-overflow, causing a linear search within each
> group at least 50% of the time.
> This can be a large part of the issue.
>
> A dimensioned array instead of a dynamic array would help your type of
> processing as well.
>
>
>
> ... 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: 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
>
> ---- ---
> 67801 731825 2197829057
>
> Sincerely,
> David Laansma
> IT Manager
> Hubbard Supply Co.
> Direct: 810-342-7143
> Office: 810-234-8681
> Fax: 810-234-6142
> www.hubbardsupply.com
> "Delivering Products, Services and Innovative Solutions"
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
> Wasylenko
> Sent: Friday, June 01, 2012 12:07 PM
> To: U2 Users List
> 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
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
> 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 type = 0, blocksize = 16384
> Split load = 10, Merge load = 5
> Split/Merge type = KEYONLY
>
> Sincerely,
> David Laansma
> IT Manager
> Hubbard Supply Co.
> Direct: 810-342-7143
> Office: 810-234-8681
> Fax: 810-234-6142
> www.hubbardsupply.com
> "Delivering Products, Services and Innovative Solutions"
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf 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 static file type, but over the
> long-term, avoids sizing issues that are the #1 reason for bad performance.
>
> Can you perform an "ANALYZE.FILE {filename}"  and post the result?
>
> ... david ...
>
> David L. Wasylenko

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread David L. Wasylenko 
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 divisible by 2, 3, 5, 7...

I get 134,147 for a reasonable modulo.
The current mod is 67,907  which is about half the calculated modulo.

50% of your data is in hash-overflow, causing a linear search within each group 
at least 50% of the time.
This can be a large part of the issue.

A dimensioned array instead of a dynamic array would help your type of 
processing as well.

 

... 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: 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

---- ---
67801 731825 2197829057

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative Solutions"


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
Wasylenko
Sent: Friday, June 01, 2012 12:07 PM
To: U2 Users List
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
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
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 type = 0, blocksize = 16384
Split load = 10, Merge load = 5
Split/Merge type = KEYONLY

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative Solutions"

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf 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 static file type, but over the long-term, 
avoids sizing issues that are the #1 reason for bad performance.

Can you perform an "ANALYZE.FILE {filename}"  and post the result?

... 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: 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:

 

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 dependent on attribute 1 and contain a variety of 
dollar amounts that are accumulated for the respective period in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the multivalued 
position of attribute 1 as well as each of the respective multivalued positions 
in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket ...

 

If, at the beginning of the year, I were to insert each of the 12-periods into 
their respective multivalues in attribute 1 and insert respective  
multivalues into attributes 2 through 30, thus performing all of the 'inserts' 
at once, will the processing each month run faster as numbers are simply 
accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many other 
attributes and the records overall are relatively large, averaging lengths of 
about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The h

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wjhonson 

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.

At least it should.  Perhaps UD has some trick where it doesn't need to do this 
for *out of group* large items, or perhaps it doesn't even have that concept in 
the first place, I'm not sure.








-Original Message-
From: Dave Laansma 
To: U2 Users List 
Sent: Fri, 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 Manager
ubbard Supply Co.
irect: 810-342-7143
ffice: 810-234-8681
ax: 810-234-6142
ww.hubbardsupply.com
Delivering Products, Services and Innovative Solutions"

Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
asylenko
ent: Friday, June 01, 2012 12:07 PM
o: U2 Users List
ubject: Re: [U2] Monthly Multivalue Inserts and Speed
What's the record count and total byte count?
... david ...
David L. Wasylenko
resident, Pick Professionals, Inc
) 314 558 1482
l...@pickpro.com

Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
ent: Friday, June 01, 2012 9:41 AM
o: U2 Users List
ubject: Re: [U2] Monthly Multivalue Inserts and Speed
Results of the ANALYZE.FILE:
Dynamic File name = WHSE.STAT
umber of groups in file (modulo) = 67801
inimum groups of file= 67801
ash type = 0, blocksize = 16384
plit load = 10, Merge load = 5
plit/Merge type = KEYONLY
Sincerely,
avid Laansma
T Manager
ubbard Supply Co.
irect: 810-342-7143
ffice: 810-234-8681
ax: 810-234-6142
ww.hubbardsupply.com
Delivering Products, Services and Innovative Solutions"
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
asylenko
ent: Friday, June 01, 2012 10:32 AM
o: U2 Users List
ubject: 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
ompared to monitoring file size of a static file type, but over the
ong-term, avoids sizing issues that are the #1 reason for bad
erformance.
Can you perform an "ANALYZE.FILE {filename}"  and post the result?
... david ...
David L. Wasylenko
resident, Pick Professionals, Inc
) 314 558 1482
l...@pickpro.com

Original Message-
rom: u2-users-boun...@listserver.u2ug.org
mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
ent: Friday, June 01, 2012 9:30 AM
o: U2-Users@listserver.u2ug.org
ubject: [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 Period, i.e. 12-01 vm 12-02 vm
2-03 etc.
Attributes 2 through 30 are dependent on attribute 1 and contain a
ariety of dollar amounts that are accumulated for the respective period
n attribute 1.
 
At the end of each month, a new G/L Period is inserted into the
ultivalued position of attribute 1 as well as each of the respective
ultivalued positions in attributes 2 through 30. Nothing complicated.
 
My question is this and is aimed largely at the technicians at Rocket
..
 
If, at the beginning of the year, I were to insert each of the
2-periods into their respective multivalues in attribute 1 and insert
espective  multivalues into attributes 2 through 30, thus
erforming all of the 'inserts' at once, will the processing each month
un faster as numbers are simply accumulated into attributes 2 through
0 and no inserting of new multivalues will have to be performed?
 
A couple nuggets of information:
 
This is only an example. In the actual file, these records contain many
ther attributes and the records overall are relatively large, averaging
engths of about 3,000 according to FILE.STAT
These are not my files so reorganizing them is not an option.
 
The heart of this question is, as a (numeric) number is accumulated in
n attribute, multivalue or subvalue, what causes the record to
stretch' in length, thus presumably impacting performance?
 
I would like to think that numeric information is stored in a more
compact' method than strings, thus using less space within the database
.. but what I 'like' and what 'is' are often quite different.
 
Thanks!
 
Sincerely,
David Laansma
IT Manager
Hubbard Supply C

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread 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: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative Solutions"


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L.
Wasylenko
Sent: Friday, June 01, 2012 12:07 PM
To: U2 Users List
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
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
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 type = 0, blocksize = 16384
Split load = 10, Merge load = 5
Split/Merge type = KEYONLY

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative Solutions"

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf 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 static file type, but over the
long-term, avoids sizing issues that are the #1 reason for bad
performance.

Can you perform an "ANALYZE.FILE {filename}"  and post the result?

... 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: 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:

 

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 dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket
...

 

If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective  multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com <http://www.hubbardsupply.com> 

"Delivering Products, Services and Innovative Solutions"

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread David L. Wasylenko 
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: 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, blocksize = 16384
Split load = 10, Merge load = 5
Split/Merge type = KEYONLY

Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative Solutions"

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf 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 static file type, but over the long-term, 
avoids sizing issues that are the #1 reason for bad performance.

Can you perform an "ANALYZE.FILE {filename}"  and post the result?

... 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: 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:

 

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 dependent on attribute 1 and contain a variety of 
dollar amounts that are accumulated for the respective period in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the multivalued 
position of attribute 1 as well as each of the respective multivalued positions 
in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket ...

 

If, at the beginning of the year, I were to insert each of the 12-periods into 
their respective multivalues in attribute 1 and insert respective  
multivalues into attributes 2 through 30, thus performing all of the 'inserts' 
at once, will the processing each month run faster as numbers are simply 
accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many other 
attributes and the records overall are relatively large, averaging lengths of 
about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in an 
attribute, multivalue or subvalue, what causes the record to 'stretch' in 
length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more 'compact' 
method than strings, thus using less space within the database ... but what I 
'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com <http://www.hubbardsupply.com> 

"Delivering Products, Services and Innovative Solutions"

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wjhonson 

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.  That's the nature of 
hashed groups.

Some vendors, IIRC, allowed the record to stay in place if it was the exact 
same size or *shorter* (and padding out the trailing FD's) but that was 
probably a mistake anyway since it kept TMI in the runtime code for that 
section instead of just 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 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 IN THE CODE - is undersize the array with a DIM ARRAY(30)
I'm used to Pr1me-style arrays, so this will stick the first 30 fields
n the first 30 elements, and dump what's left in element 0. (If you use
ick-style arrays you'll need to DIM (31) and they'll go in element 31).
That way, you get all the benefit of working with your first 30 fields
ice and fast, but you don't get hammered on read and write with
reaking all the other fields out.
Did I say make sure it's documented? Other programmers can get a nasty
urprise if they don't realise that's what you've done.
btw, I guess you're on UD? My experience is UV, but I think the BASIC is
retty much the same even at that level?
Cheers,
ol
> -Original Message-
 From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of Dave 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 
onger each month. Here is briefly how the attributes are organized, a 
elatively 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 dependent on attribute 1 and contain a variety of 
ollar amounts that are accumulated for the respective period in attribute 1.
 
  
 
 At the end of each month, a new G/L Period is inserted into the multivalued 
osition of attribute 1 as well as each of the respective multivalued positions 
n attributes 2 through 30. Nothing complicated.
 
  
 
 My question is this and is aimed largely at the technicians at Rocket ...
 
  
 
 If, at the beginning of the year, I were to insert each of the 12-periods into 
heir respective multivalues in attribute 1 and insert respective  
ultivalues into attributes 2 through 30, thus performing all of the 'inserts' 
t once, will the processing each month run faster as numbers are simply 
ccumulated into attributes 2 through
 30 and no inserting of new multivalues will have to be performed?
 
  
 
 A couple nuggets of information:
 
  
 
 This is only an example. In the actual file, these records contain many other 
ttributes and the records overall are relatively large, averaging lengths of 
bout 3,000 according to FILE.STAT
 
 These are not my files so reorganizing them is not an option.
 
  
 
 The heart of this question is, as a (numeric) number is accumulated in an 
ttribute, multivalue or subvalue, what causes the record to 'stretch' in 
ength, thus presumably impacting performance?
 
  
 
 I would like to think that numeric information is stored in a more 'compact' 
ethod than strings, thus using less space within the database ... but what I 
like' and what 'is' are often quite different.
 
  
 
 Thanks!
 
  
 
 Sincerely,
 
 David Laansma
 
 IT Manager
 
 Hubbard Supply Co.
 
 Direct: 810-342-7143
 
 Office: 810-234-8681
 
 Fax: 810-234-6142
 
 www.hubbardsupply.com <http://www.hubbardsupply.com> 
 
 "Delivering Products, Services and Innovative Solutions"
 
  
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-users
 
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wjhonson 

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 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 simple example:
 
Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm
2-03 etc.
Attributes 2 through 30 are dependent on attribute 1 and contain a
ariety of dollar amounts that are accumulated for the respective period
n attribute 1.
 
At the end of each month, a new G/L Period is inserted into the
ultivalued position of attribute 1 as well as each of the respective
ultivalued positions in attributes 2 through 30. Nothing complicated.
 
My question is this and is aimed largely at the technicians at Rocket
..
 
If, at the beginning of the year, I were to insert each of the
2-periods into their respective multivalues in attribute 1 and insert
espective  multivalues into attributes 2 through 30, thus
erforming all of the 'inserts' at once, will the processing each month
un faster as numbers are simply accumulated into attributes 2 through
0 and no inserting of new multivalues will have to be performed?
 
A couple nuggets of information:
 
This is only an example. In the actual file, these records contain many
ther attributes and the records overall are relatively large, averaging
engths of about 3,000 according to FILE.STAT
These are not my files so reorganizing them is not an option.
 
The heart of this question is, as a (numeric) number is accumulated in
n attribute, multivalue or subvalue, what causes the record to
stretch' in length, thus presumably impacting performance?
 
I would like to think that numeric information is stored in a more
compact' method than strings, thus using less space within the database
.. but what I 'like' and what 'is' are often quite different.
 
Thanks!
 
Sincerely,
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com <http://www.hubbardsupply.com> 
"Delivering Products, Services and Innovative Solutions"
 
___
2-Users mailing list
2-us...@listserver.u2ug.org
ttp://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Wols Lists 
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 ARRAY(30)

I'm used to Pr1me-style arrays, so this will stick the first 30 fields
in the first 30 elements, and dump what's left in element 0. (If you use
Pick-style arrays you'll need to DIM (31) and they'll go in element 31).

That way, you get all the benefit of working with your first 30 fields
nice and fast, but you don't get hammered on read and write with
breaking all the other fields out.

Did I say make sure it's documented? Other programmers can get a nasty
surprise if they don't realise that's what you've done.

btw, I guess you're on UD? My experience is UV, but I think the BASIC is
pretty much the same even at that level?

Cheers,
Wol

> -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
> 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 our G/L Period, i.e. 12-01 vm 12-02 vm
> 12-03 etc.
> 
> Attributes 2 through 30 are dependent on attribute 1 and contain a variety of 
> dollar amounts that are accumulated for the respective period in attribute 1.
> 
>  
> 
> At the end of each month, a new G/L Period is inserted into the multivalued 
> position of attribute 1 as well as each of the respective multivalued 
> positions in attributes 2 through 30. Nothing complicated.
> 
>  
> 
> My question is this and is aimed largely at the technicians at Rocket ...
> 
>  
> 
> If, at the beginning of the year, I were to insert each of the 12-periods 
> into their respective multivalues in attribute 1 and insert respective  
> multivalues into attributes 2 through 30, thus performing all of the 
> 'inserts' at once, will the processing each month run faster as numbers are 
> simply accumulated into attributes 2 through
> 30 and no inserting of new multivalues will have to be performed?
> 
>  
> 
> A couple nuggets of information:
> 
>  
> 
> This is only an example. In the actual file, these records contain many other 
> attributes and the records overall are relatively large, averaging lengths of 
> about 3,000 according to FILE.STAT
> 
> These are not my files so reorganizing them is not an option.
> 
>  
> 
> The heart of this question is, as a (numeric) number is accumulated in an 
> attribute, multivalue or subvalue, what causes the record to 'stretch' in 
> length, thus presumably impacting performance?
> 
>  
> 
> I would like to think that numeric information is stored in a more 'compact' 
> method than strings, thus using less space within the database ... but what I 
> 'like' and what 'is' are often quite different.
> 
>  
> 
> Thanks!
> 
>  
> 
> Sincerely,
> 
> David Laansma
> 
> IT Manager
> 
> Hubbard Supply Co.
> 
> Direct: 810-342-7143
> 
> Office: 810-234-8681
> 
> Fax: 810-234-6142
> 
> www.hubbardsupply.com <http://www.hubbardsupply.com> 
> 
> "Delivering Products, Services and Innovative Solutions"
> 
>  
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Dave Laansma 
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 Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
"Delivering Products, Services and Innovative Solutions"

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf 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 static file type, but over the
long-term, avoids sizing issues that are the #1 reason for bad
performance.

Can you perform an "ANALYZE.FILE {filename}"  and post the result?

... 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: 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:

 

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 dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket
...

 

If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective  multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com <http://www.hubbardsupply.com> 

"Delivering Products, Services and Innovative Solutions"

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

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



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 dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.



At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.



My question is this and is aimed largely at the technicians at Rocket
...



If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective  multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?



A couple nuggets of information:



This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.



The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?



I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.



Thanks!



Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com <http://www.hubbardsupply.com>

"Delivering Products, Services and Innovative Solutions"



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, R&D

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]

[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]<http://www.harriscomputer.com/>
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.com<http://www.harris-schoolsolutions.com>

This message is intended exclusively for the individual or entity to which it 
is addressed. This communication may contain information that is proprietary, 
privileged or confidential or otherwise legally exempt from disclosure. If you 
are not the named addressee, you are not authorized to read, print, retain, 
copy or disseminate this message or any part of it. If you have received this 
message in error, please notify the sender immediately by e-mail and delete all 
copies of the message.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread David L. Wasylenko 
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.FILE {filename}"  and post the result?

... 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: 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:

 

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 dependent on attribute 1 and contain a variety of 
dollar amounts that are accumulated for the respective period in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the multivalued 
position of attribute 1 as well as each of the respective multivalued positions 
in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket ...

 

If, at the beginning of the year, I were to insert each of the 12-periods into 
their respective multivalues in attribute 1 and insert respective  
multivalues into attributes 2 through 30, thus performing all of the 'inserts' 
at once, will the processing each month run faster as numbers are simply 
accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many other 
attributes and the records overall are relatively large, averaging lengths of 
about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in an 
attribute, multivalue or subvalue, what causes the record to 'stretch' in 
length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more 'compact' 
method than strings, thus using less space within the database ... but what I 
'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com <http://www.hubbardsupply.com> 

"Delivering Products, Services and Innovative Solutions"

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Monthly Multivalue Inserts and Speed

2012-06-01 Thread Israel, John R. 
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
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 our G/L Period, i.e. 12-01 vm 12-02 vm
12-03 etc.

Attributes 2 through 30 are dependent on attribute 1 and contain a variety of 
dollar amounts that are accumulated for the respective period in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the multivalued 
position of attribute 1 as well as each of the respective multivalued positions 
in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket ...

 

If, at the beginning of the year, I were to insert each of the 12-periods into 
their respective multivalues in attribute 1 and insert respective  
multivalues into attributes 2 through 30, thus performing all of the 'inserts' 
at once, will the processing each month run faster as numbers are simply 
accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many other 
attributes and the records overall are relatively large, averaging lengths of 
about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in an 
attribute, multivalue or subvalue, what causes the record to 'stretch' in 
length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more 'compact' 
method than strings, thus using less space within the database ... but what I 
'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com <http://www.hubbardsupply.com> 

"Delivering Products, Services and Innovative Solutions"

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[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 dependent on attribute 1 and contain a
variety of dollar amounts that are accumulated for the respective period
in attribute 1.

 

At the end of each month, a new G/L Period is inserted into the
multivalued position of attribute 1 as well as each of the respective
multivalued positions in attributes 2 through 30. Nothing complicated.

 

My question is this and is aimed largely at the technicians at Rocket
...

 

If, at the beginning of the year, I were to insert each of the
12-periods into their respective multivalues in attribute 1 and insert
respective  multivalues into attributes 2 through 30, thus
performing all of the 'inserts' at once, will the processing each month
run faster as numbers are simply accumulated into attributes 2 through
30 and no inserting of new multivalues will have to be performed?

 

A couple nuggets of information:

 

This is only an example. In the actual file, these records contain many
other attributes and the records overall are relatively large, averaging
lengths of about 3,000 according to FILE.STAT

These are not my files so reorganizing them is not an option.

 

The heart of this question is, as a (numeric) number is accumulated in
an attribute, multivalue or subvalue, what causes the record to
'stretch' in length, thus presumably impacting performance?

 

I would like to think that numeric information is stored in a more
'compact' method than strings, thus using less space within the database
... but what I 'like' and what 'is' are often quite different.

 

Thanks!

 

Sincerely,

David Laansma

IT Manager

Hubbard Supply Co.

Direct: 810-342-7143

Office: 810-234-8681

Fax: 810-234-6142

www.hubbardsupply.com  

"Delivering Products, Services and Innovative Solutions"

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users