Text database using custom properties

[Lynch, Jonathan]

I wrote a program that does some of the things you are talking about. It
stores data in custom properties of a couple of buttons, and then
autosaves each memo (or in my case each task) to a separate file
whenever you change from one task to another.

It works real well, and is pretty much instantaneous. Rev seems to
process data in custom properties quite quickly.

Even for 10,000 memos, I bet your performance will be acceptable. I
would suggest that all of your memos be saved in their own file. This
means you can program it to autosave each memo when you are done with
it. 

Let me know if you want to check out the program, and I can give you a
link. It's got a ton of coding in it, so I might have to tell you where
to look in the scripts to find out how to do particular things.

Cheers,

Jonathan

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of Brian
Alleyne
Sent: Friday, December 09, 2005 7:14 PM
To: use-revolution at lists.runrev.com
Subject: Text database using custom properties

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 to seek 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,  10000 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