Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

2012-06-04 Thread Daniel McGrath 
Note: This is only true for UniVerse which implements an internal hint 
mechanism. This will not provide the desired effect in UniData.

Also note, correctly using LOOP/REMOVE will outperform the RAISE/LOWER method 
as it doesn't do the 2 extra laps of string scanning and modified delimiters.

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor
Sent: Monday, June 04, 2012 2:48 PM
To: U2 Users List
Subject: Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

If someone has already suggested this then forgive me as I haven't been 
following this discussion in great detail.

Since you are handling the records in a dimensioned array you can RAISE() each 
element, process each element as attributes where field caching will come into 
play, then LOWER() them prior to writing them to disk.  You should be amazed at 
how much faster this can be.

Assuming all elements of the array are multivalued (if not you'll have to hard 
code which elements are multivalued) ...

MATREADU DX FROM .
DX.ELEMENTS = INMAT()   
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = RAISE(DX(AMC))
NEXT AMC
... Process them as attribute-delimited arrays
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = LOWER(DX(AMC))
NEXT AMC

Perry Taylor
Zirmed, Inc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, June 04, 2012 2:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)


Equating doesn't "reserve a spot", so I assume you mean dimensioning "reserves 
a spot"
All equating does is, at compile time, it replaces one variable name with 
another.
It has no effect at run time.



-Original Message-
From: Nick Gettino 
To: 'u2-users@listserver.u2ug.org' 
Sent: Mon, Jun 4, 2012 1:07 pm
Subject: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)



s John stated we use dimensioned arrays but we also equate each attribute which 
eserves a spot for the piece of data making it tremendously faster updating.

Nicholas M Gettino, Director of Professional Services & Support, EnRoute 
mergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, 
uite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX
678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com 
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org]
n Behalf Of u2-users-requ...@listserver.u2ug.org
ent: Friday, June 01, 2012 3:00 PM
o: u2-users@listserver.u2ug.org
ubject: U2-Users Digest, Vol 38, Issue 1 Send U2-Users mailing list submissions 
to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide 
Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users
r, via email, send a message with subject or body 'help' to 
u2-users-requ...@listserver.u2ug.org
You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org
When replying, please edit your Subject line so it is more specific han "Re: 
Contents of U2-Users digest..."

oday's Topics:
   1. Monthly Multivalue Inserts and Speed (Dave Laansma)
  2. Re: Monthly Multivalue Inserts and Speed (Israel, John R.)
  3. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
  4. Re: Monthly Multivalue Inserts and Speed (Dave Davis)
  5. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
  6. Re: Monthly Multivalue Inserts and Speed (Wols Lists)
  7. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  8. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  9. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)  10. Re: 
Monthly Multivalue Inserts and Speed (Dave Laansma)  11. Re: Monthly Multivalue 
Inserts and Speed (Wjhonson)  12. Re: Monthly Multivalue Inserts and Speed 
(David L. Wasylenko)

-
Message: 1
ate: Fri, 1 Jun 2012 10:29:55 -0400
rom: "Dave Laansma" 
o: 
ubject: [U2] Monthly Multivalue Inserts and Speed
essage-ID:
<071256f97fa0fa498115009ae88175b202cad...@hubmail2.hubbardsupply.com>
ontent-Type: text/plain;charset="us-ascii"
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 o

Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

2012-06-04 Thread Perry Taylor 
If someone has already suggested this then forgive me as I haven't been 
following this discussion in great detail.

Since you are handling the records in a dimensioned array you can RAISE() each 
element, process each element as attributes where field caching will come into 
play, then LOWER() them prior to writing them to disk.  You should be amazed at 
how much faster this can be.

Assuming all elements of the array are multivalued (if not you'll have to hard 
code which elements are multivalued) ...

MATREADU DX FROM .
DX.ELEMENTS = INMAT()   
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = RAISE(DX(AMC))
NEXT AMC
... Process them as attribute-delimited arrays
FOR AMC = 1 TO DX.ELEMENTS
   DX(AMC) = LOWER(DX(AMC))
NEXT AMC

Perry Taylor
Zirmed, Inc.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Monday, June 04, 2012 2:31 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)


Equating doesn't "reserve a spot", so I assume you mean dimensioning "reserves 
a spot"
All equating does is, at compile time, it replaces one variable name with 
another.
It has no effect at run time.



-Original Message-
From: Nick Gettino 
To: 'u2-users@listserver.u2ug.org' 
Sent: Mon, Jun 4, 2012 1:07 pm
Subject: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)



s John stated we use dimensioned arrays but we also equate each attribute which 
eserves a spot for the piece of data making it tremendously faster updating.

Nicholas M Gettino, Director of Professional Services & Support, EnRoute 
mergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, 
uite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX 
678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of u2-users-requ...@listserver.u2ug.org
ent: Friday, June 01, 2012 3:00 PM
o: u2-users@listserver.u2ug.org
ubject: U2-Users Digest, Vol 38, Issue 1
Send U2-Users mailing list submissions to
u2-users@listserver.u2ug.org
To subscribe or unsubscribe via the World Wide Web, visit
http://listserver.u2ug.org/mailman/listinfo/u2-users
r, via email, send a message with subject or body 'help' to
u2-users-requ...@listserver.u2ug.org
You can reach the person managing the list at
u2-users-ow...@listserver.u2ug.org
When replying, please edit your Subject line so it is more specific
han "Re: Contents of U2-Users digest..."

oday's Topics:
   1. Monthly Multivalue Inserts and Speed (Dave Laansma)
  2. Re: Monthly Multivalue Inserts and Speed (Israel, John R.)
  3. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
  4. Re: Monthly Multivalue Inserts and Speed (Dave Davis)
  5. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
  6. Re: Monthly Multivalue Inserts and Speed (Wols Lists)
  7. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  8. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  9. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
 10. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
 11. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
 12. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)

-
Message: 1
ate: Fri, 1 Jun 2012 10:29:55 -0400
rom: "Dave Laansma" 
o: 
ubject: [U2] Monthly Multivalue Inserts and Speed
essage-ID:
<071256f97fa0fa498115009ae88175b202cad...@hubmail2.hubbardsupply.com>
ontent-Type: text/plain;charset="us-ascii"
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

Re: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)

2012-06-04 Thread Wjhonson 

Equating doesn't "reserve a spot", so I assume you mean dimensioning "reserves 
a spot"
All equating does is, at compile time, it replaces one variable name with 
another.
It has no effect at run time.



-Original Message-
From: Nick Gettino 
To: 'u2-users@listserver.u2ug.org' 
Sent: Mon, Jun 4, 2012 1:07 pm
Subject: [U2] 13. Re: Monthly Multivalue Inserts and Speed (Nick Gettino)



s John stated we use dimensioned arrays but we also equate each attribute which 
eserves a spot for the piece of data making it tremendously faster updating.

Nicholas M Gettino, Director of Professional Services & Support, EnRoute 
mergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, 
uite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX 
678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com
-Original Message-
rom: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 
n Behalf Of u2-users-requ...@listserver.u2ug.org
ent: Friday, June 01, 2012 3:00 PM
o: u2-users@listserver.u2ug.org
ubject: U2-Users Digest, Vol 38, Issue 1
Send U2-Users mailing list submissions to
u2-users@listserver.u2ug.org
To subscribe or unsubscribe via the World Wide Web, visit
http://listserver.u2ug.org/mailman/listinfo/u2-users
r, via email, send a message with subject or body 'help' to
u2-users-requ...@listserver.u2ug.org
You can reach the person managing the list at
u2-users-ow...@listserver.u2ug.org
When replying, please edit your Subject line so it is more specific
han "Re: Contents of U2-Users digest..."

oday's Topics:
   1. Monthly Multivalue Inserts and Speed (Dave Laansma)
  2. Re: Monthly Multivalue Inserts and Speed (Israel, John R.)
  3. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
  4. Re: Monthly Multivalue Inserts and Speed (Dave Davis)
  5. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
  6. Re: Monthly Multivalue Inserts and Speed (Wols Lists)
  7. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  8. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
  9. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)
 10. Re: Monthly Multivalue Inserts and Speed (Dave Laansma)
 11. Re: Monthly Multivalue Inserts and Speed (Wjhonson)
 12. Re: Monthly Multivalue Inserts and Speed (David L. Wasylenko)

-
Message: 1
ate: Fri, 1 Jun 2012 10:29:55 -0400
rom: "Dave Laansma" 
o: 
ubject: [U2] Monthly Multivalue Inserts and Speed
essage-ID:
<071256f97fa0fa498115009ae88175b202cad...@hubmail2.hubbardsupply.com>
ontent-Type: text/plain;charset="us-ascii"
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  
"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/mail