Text database using custom properties

Devin Asay devin_asay at byu.edu
Wed Dec 14 15:20:41 EST 2005


Brian,

I'm no expert on these subjects, but I offer a couple of observations  
from my experience:

	- You'd probably want to save an optimized, plain text version of  
each memo, indexed to the styled-text memo, to speed up the search.
	- both the 'find' and 'offset' commands are very fast, even on long  
texts.
	- Could you read the text in from an external file, say, into a  
variable, then do the search. Reading in external files is also very  
fast.
	- If you plan on doing complex searches you might be better off in a  
SQL environment.

Devin

On Dec 9, 2005, at 3:44 AM, BRIAN ALLEYNE wrote:

> Hi all
>
>  I am building a note and outline manager in rev. I've worked out  
> my user interface, but before going further I wanted some advice on  
> text handling before working on the data engine.
>
>  I will store  memo fields of various lengths, these would have  
> styled text, and would be typed in or imported in html or rtf form  
> from other applications. Some of these memo fields could run to 50  
> or 60 pages of text.  I will need to quickly search for any word or  
> string in these memo fields. I expect to store potentially  
> thousands of these memo fields.
>
>  I was thinking of creating a data stack and storing the memo  
> fields as custom properties - in essence using rev as my database.  
> I've read Dan Shafer and Richard Gaskin on this, and if I  
> understand them, it seems as if this is a reasonable way to go.
>
>  In sum, is rev good for a freetext database with thousands of  
> memos or should I be looking at something like Valentina?
>
>  I am worried about the performance hit on searching when my  
> database grows to say 10, 000 memos.
>
>  Any advice is welcome.
>
>  best regards,
>
>  Brian
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>

Devin Asay
Humanities Technology and Research Support Center
Brigham Young University




More information about the use-livecode mailing list