Text database using custom properties

[simplsol at aol.com]

Brian,
 Your approach sounds good.
 We have been doing something similar.
  We started with HyperCard stacks with tens of thousands, and hundreds 
of thousands, of records. Converting them to Rev stacks bloated them 
significantly; 2 meg. HC stacks ballooned to almost 8 meg. Using a text 
file for the data required less than 2 meg.
  Going to custom properties will (in our experience) increase speed of 
access to the data 3 to 10 times. CPs will also help you avoid one 
limit in Rev: lines in fields can not be more than approx. 65k 
(normally not an issue, but a significant one when using lines to 
display database records.
 Paul Looney

 -----Original Message-----
 From: Brian Alleyne <b.alleyne at btinternet.com>
 To: use-revolution at lists.runrev.com
 Sent: Sat, 10 Dec 2005 00:13:52 +0000
 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