[159] in Tooltime
Re: What got done today.
daemon@ATHENA.MIT.EDU (Steven Wade Neiterman)
Sat Jul 13 16:23:01 1996
Date: Sat, 13 Jul 1996 16:25:48 -0400
To: Lynne E Sousa <sousa@MIT.EDU>
From: wade@MIT.EDU (Steven Wade Neiterman)
Cc: tooltime@MIT.EDU
>
>I turned on quieries on the history text field. You should now be getting sub
>sets instead of all records.
>
I did some testing and was not able to get the history field to search.
At first, the problem seemed to be that the where clause is empty. When I
changed it to read "where 0=0 and mit_history like '%pop%', I got a
database error.
According to the Oracle book, not only can a long data type not be indexed
(which we knew), but a long type type can not be in a where clause (which
Terry thought would work - allowing for a table scan and thus a longer
period to retrieve the records).
Trying to think of options, I wonder if we created a new field, e.g.
mit_history_search, which had the last 2,000 characters (max. number of
characters than can fit in a datatype of Char) of the mit_history field.
The mit_history_search field could be indexed and thus searchable.
I don't know if this option is possible or if this is this worth the
effort? Brett/Lynne - can we write a Tcl routine to strip the last 2k
characters on an Update/Insert and store this in a new field -
mit_history_search? Are there other options?
..Steve
