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
[email protected]
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
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
