G'day Atrix, Since nobody more knowledgeable has jumped in...
At 14:46 19/10/02 -0700, you wrote:
hello, im considering setting an index on a text (50) column we have in a table. We have to do quite a few sget()'s on this column so it runs slow under some circumstances and am looking to speed it up. My question is 2 fold i guess...first of all...are there other ways besides indexing to speed up such a column? And my second question is that when i create an index on this column it asks how many of the characters i want to hash and that the rest will be preserved. I know what hashing is...taking a string of data, putting it through a function and the result is a smaller peice of data (im assuming is used as the index value?)
Believe so...
I was wondering though in such a situation is it better to have more of it hashed or less?I believe hashing more takes up more space in the rb3 file.
and in general...what are the pros and cons of hasing more as opposed to less?
I have not worried overly about doing that as I figure if
you need an index a hammer won't do. In this scenario I
would index the lot.
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
"... the control of impulse -- is the first principle of civilization."-- Will Durant,
Pulitzer Prize winning philosopher, writer and historian
the most needed product in the world can be found at
www.thewaytohappiness.org
This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
