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