Re: [U2] Slow READ/WRITE with indexes (Nick Gettino)
Hundreds of characters.
My example concatenates a bunch of attributes like name and address together to
see if there are any matching records already on file, before creating a new
record. I set the alternate key length to 160 for this one index, and nothing
bad happened (so far).
I use that with the setindex, readfwd, etc unibasic commands in a subroutine to
return the matching record id, or nothing if not found.
Haven't had a need to go any bigger than that.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune
Sent: Friday, September 10, 2010 4:04 PM
To: U2 Users List
Subject: Re: [U2] Slow READ/WRITE with indexes (Nick Gettino)
How long of a data string to you want to index?
This mostly has a bearing on the block-size of the index file (the key length
setting)
Wally Terhune
U2 Support Architect
Rocket Software
4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA
Tel: +1.720.475.8055
Email: wterh...@rs.com
Web: www.rocketsoftware.com/u2
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis
Sent: Friday, September 10, 2010 1:24 PM
To: U2 Users List
Subject: Re: [U2] Slow READ/WRITE with indexes (Nick Gettino)
Does building the biggest first really matter, or is it more important to just
put the right value in the key size prompt you get asked for on the first
index you create?
Also, does anyone know in UniData how big a key size you can give on an index?
I know it's bigger than the 120-something you are limited to for the file key,
but I've never seen a documented limit.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nick Gettino
Sent: Friday, September 10, 2010 3:19 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Slow READ/WRITE with indexes (Nick Gettino)
On Unidata you can do a LIST.INDEX 'FILENAME' ALL STATS
This will give you each index the number of keys how many are in overflow and a
couple of other things.
If you can't tell from that command use
LIST.INDEX 'FILE.NAME' ALL DETAILS
This will show you how many records per key and whether the index item is in
overflow.
As mentioned use the NO.NULLS and or NO.DUPS to build the index.
And this has been a killer for us. You have to ALWAYS build the biggest index
first.
By biggest I mean the dictionary length being used.
Example. If you have city, state zip, order# and date. 40L, 15R, 8R
respectively that is how they should be built.
Nicholas M Gettino - Director of Support Professional Services | EnRoute
Emergency Systems an Infor Company, 401 E Jackson Street, Suite 1500, Tampa
Florida 33602 | Office 813-207-6998 |Fax 678-393-5389
|nick.gett...@enroute911.com / www.enroute911.com
Register Now- Early Bird Discount Available |
enroute911.com/user-conference-2010 | EnRoute User Conference | Disney's Yacht
Club Resort, Lake Buena Vista, FL | September 28- October 1, 2010
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
u2-users-requ...@listserver.u2ug.org
Sent: 09/10/2010 3:00 PM
To: u2-users@listserver.u2ug.org
Subject: U2-Users Digest, Vol 17, Issue 8
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
or, 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
than Re: Contents of U2-Users digest...
Today's Topics:
1. Re: Sequential Files Question (Colin Alfke)
2. Re: Sequential Files Question (Bill Haskett)
3. Re: Slow READ/WRITE with indexes (Ryan M)
4. Re: Slow READ/WRITE with indexes (Ryan M)
5. Re: Slow READ/WRITE with indexes {Unclassified}
(HENDERSON MIKE, MR)
6. Re: Slow READ/WRITE with indexes (Colin Alfke)
7. Re: Sequential Files Question (Colin Alfke)
8. Re: Sequential Files Question (Bill Haskett)
9. Re: Slow READ/WRITE with indexes {Unclassified} (Wols Lists)
10. Re: Slow READ/WRITE with indexes {Unclassified} (Dan McGrath)
11. Re: Slow READ/WRITE with indexes (Boydell, Stuart)
12. Re: Slow READ/WRITE with indexes (Ryan M)
13. Re: Slow READ/WRITE with indexes {Unclassified} (Ryan M)
14. Re: Slow READ/WRITE with indexes (Ryan M)
15. UD - XDOMLocate problem - solved (Edward Brown)
16. Re: Slow READ/WRITE with indexes {Unclassified} (Wols Lists)
--
Message: 1
Date: Thu, 9 Sep 2010 13:02:10 -0600
From: Colin Alfke alfke...@hotmail.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Subject:
[U2] [UV] Is anyone storing multi-byte names or addresses
Hey, Just wondering how others have approached this - storing multi-byte names and addresses for non-English languages. I don't think we're approaching the demarcation line where an NLS implementation would be warranted, with the Administrative overhead that incurs. We are doing a lot more other language business though since we are opening more and more off-shore call centers, and have deployed multiple non English language websites. Our immediate need just relates to Name, and ship to / bill to addresses, such words as Mosiężno-Żelaznych. Thanks in advance for the always enlightening insights. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Is anyone storing multi-byte names or addresses
We do store multi byte stuff, the biggest issues we have are not in the storing but in its identification so that you can then transport and display it correctly, we often get the data in xml files so we need to know that the file has the correct character set definition, similarly the data is displayed in a browser via html so again we need to know that the correct character set is used, and certainly not mix character sets on one output, ascii/utf8 combination is fine, but you can get in knots if you start to combine iso8859-1 with utf8 as the characters 127-255 are single byte in iso8859-1 but double byte in utf8. In some ways utf8 is better than is08859-1 as you don't get the u umlout issue as character 253. You can of course mix character sets in your data, so long as you know what is what. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 13 September 2010 16:38 To: 'U2 Users List' Subject: [U2] [UV] Is anyone storing multi-byte names or addresses Hey, Just wondering how others have approached this - storing multi-byte names and addresses for non-English languages. I don't think we're approaching the demarcation line where an NLS implementation would be warranted, with the Administrative overhead that incurs. We are doing a lot more other language business though since we are opening more and more off-shore call centers, and have deployed multiple non English language websites. Our immediate need just relates to Name, and ship to / bill to addresses, such words as Mosiężno-Żelaznych. Thanks in advance for the always enlightening insights. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] EMailing from Universe
End users are picky. They want to be able to send pretty formatted HTML
message bodies and mixed MIME multipart messages with Excel spreadsheets
and .pdf's and .jpgs' attached.
Symeon Breen wrote:
What could be simpler than the shell commands i gave examples of - why would
you complicate it with a python script ?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: 12 September 2010 21:11
To: U2 Users List
Subject: Re: [U2] EMailing from Universe
Python script will make quick work of this.
On 9/12/10, Symeon Breen syme...@gmail.com wrote:
If you are on linux use either mutt or mail
e.g. EXECUTE !mutt -a {fileToAttach} -s {subject}
emailaddress,emailaddress2 /dev/null
or EXECUTE '!echo hello world | mail -s {subject} emailaddress
we send thousands of mails every week using this method.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Warner
Sent: 12 September 2010 04:31
To: u2-users@listserver.u2ug.org
Subject: [U2] EMailing from Universe
We're started a project where a client wants to email statements to their
customers. Has anyone done this with success, and if so, can you point me
in a direction?
___
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
--
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EMailing from Universe
The pretty content is separate to the sending mechanism - you can create a
mime document in many ways and use the mutt or mail command to send it in
just the same manner.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: 13 September 2010 17:44
To: U2 Users List
Subject: Re: [U2] EMailing from Universe
End users are picky. They want to be able to send pretty formatted HTML
message bodies and mixed MIME multipart messages with Excel spreadsheets
and .pdf's and .jpgs' attached.
Symeon Breen wrote:
What could be simpler than the shell commands i gave examples of - why
would
you complicate it with a python script ?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: 12 September 2010 21:11
To: U2 Users List
Subject: Re: [U2] EMailing from Universe
Python script will make quick work of this.
On 9/12/10, Symeon Breen syme...@gmail.com wrote:
If you are on linux use either mutt or mail
e.g. EXECUTE !mutt -a {fileToAttach} -s {subject}
emailaddress,emailaddress2 /dev/null
or EXECUTE '!echo hello world | mail -s {subject} emailaddress
we send thousands of mails every week using this method.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Warner
Sent: 12 September 2010 04:31
To: u2-users@listserver.u2ug.org
Subject: [U2] EMailing from Universe
We're started a project where a client wants to email statements to their
customers. Has anyone done this with success, and if so, can you point
me
in a direction?
___
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
--
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
___
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] EMailing from Universe
Or sendmail and blat which is what I'm using.
My point is that using mutt as you describe sends whatever file you
specify as an attachment, not as the body of the message.
Symeon Breen wrote:
The pretty content is separate to the sending mechanism - you can create a
mime document in many ways and use the mutt or mail command to send it in
just the same manner.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: 13 September 2010 17:44
To: U2 Users List
Subject: Re: [U2] EMailing from Universe
End users are picky. They want to be able to send pretty formatted HTML
message bodies and mixed MIME multipart messages with Excel spreadsheets
and .pdf's and .jpgs' attached.
Symeon Breen wrote:
What could be simpler than the shell commands i gave examples of - why
would
you complicate it with a python script ?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: 12 September 2010 21:11
To: U2 Users List
Subject: Re: [U2] EMailing from Universe
Python script will make quick work of this.
On 9/12/10, Symeon Breen syme...@gmail.com wrote:
If you are on linux use either mutt or mail
e.g. EXECUTE !mutt -a {fileToAttach} -s {subject}
emailaddress,emailaddress2 /dev/null
or EXECUTE '!echo hello world | mail -s {subject} emailaddress
we send thousands of mails every week using this method.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Warner
Sent: 12 September 2010 04:31
To: u2-users@listserver.u2ug.org
Subject: [U2] EMailing from Universe
We're started a project where a client wants to email statements to their
customers. Has anyone done this with success, and if so, can you point
me
in a direction?
___
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
--
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EMailing from Universe
Ah ok I see
We usually generate an html email, mime encode it into a text file and do
something like
cat mimeFile | mail -s {subject} emailaddress
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: 13 September 2010 18:51
To: U2 Users List
Subject: Re: [U2] EMailing from Universe
Or sendmail and blat which is what I'm using.
My point is that using mutt as you describe sends whatever file you
specify as an attachment, not as the body of the message.
Symeon Breen wrote:
The pretty content is separate to the sending mechanism - you can create a
mime document in many ways and use the mutt or mail command to send it in
just the same manner.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
Sent: 13 September 2010 17:44
To: U2 Users List
Subject: Re: [U2] EMailing from Universe
End users are picky. They want to be able to send pretty formatted HTML
message bodies and mixed MIME multipart messages with Excel spreadsheets
and .pdf's and .jpgs' attached.
Symeon Breen wrote:
What could be simpler than the shell commands i gave examples of - why
would
you complicate it with a python script ?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: 12 September 2010 21:11
To: U2 Users List
Subject: Re: [U2] EMailing from Universe
Python script will make quick work of this.
On 9/12/10, Symeon Breen syme...@gmail.com wrote:
If you are on linux use either mutt or mail
e.g. EXECUTE !mutt -a {fileToAttach} -s {subject}
emailaddress,emailaddress2 /dev/null
or EXECUTE '!echo hello world | mail -s {subject} emailaddress
we send thousands of mails every week using this method.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Warner
Sent: 12 September 2010 04:31
To: u2-users@listserver.u2ug.org
Subject: [U2] EMailing from Universe
We're started a project where a client wants to email statements to
their
customers. Has anyone done this with success, and if so, can you point
me
in a direction?
___
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
--
Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com
___
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
