AW: All this talk about DataBases - but how to select?

[Tiemo Hollmann TB]

Hi Jacqueline,
thanks for sharing your approach. I tested to store the datas in user
properties and load them into arrays and read them with repeat structures up
to 20,000 records. It worked, but not as fast as SQL and the code was not
that nice and compact as with SQL. MARK CARDS I have never thought about to
access my datas. Perhaps a try next time.
Thanks
Tiemo

> -----Ursprüngliche Nachricht-----
> Von: use-revolution-bounces at lists.runrev.com [mailto:use-revolution-
> bounces at lists.runrev.com] Im Auftrag von J. Landman Gay
> Gesendet: Mittwoch, 30. Mai 2007 21:19
> An: How to use Revolution
> Betreff: Re: All this talk about DataBases - but how to select?
> 
> Tiemo Hollmann TB wrote:
> > Now I have to get into this very interesting thread as a rev novice too.
> >
> > Storing data is one thing and the possibilities of rev are really
> perfect.
> > But how do you get a good performance accesing the however stored datas
> in a
> > stack (cards / properties / properties loaded into arrays)?
> >
> > Saying I want a simple "find all records including / starting with a
> search
> > string and some other filters"  a simple "SQL SELECT WHERE" does all the
> > work for me in a very good performance. Storing the datas in whatever
> self
> > made rev structures I have to go with REPEAT LOOPS thru all records,
> using
> > perhaps LINEOFFSET() and some IF THEN comparisons. For my experience yet
> it
> > is not that performant as SQL with say 10,000 records. But probably I am
> > still missing some sophisticated indexing technics which I don't see
> yet.
> > Anyone willing to share your search / find technology with properties or
> > arrays?
> 
> With that much data, a SQL database is better. For smaller databases,
> you can create one card per record and use the "mark" command to flag
> the cards that match. For example:
> 
>    mark cards by finding "my string"
> 
> or:
> 
>    mark cards by finding whole "my string" in field 2
> 
> or:
> 
>    mark cards where the hilite of btn 1 is true
> 
> or:
> 
>    mark cards where field 1 contains "my string" and field 3 = "true"
> 
> Then you loop through the marked cards to get the information you want.
> This isn't as fast as a dedicated database but is often good enough for
> small data sets. You can use any variation of the "find" command (find
> string, find words, find whole, etc.) to mark the cards. This way you
> don't need to loop through all the cards. When you are done, unmark all
> cards.
> 
> --
> Jacqueline Landman Gay         |     jacque at hyperactivesw.com
> HyperActive Software           |     http://www.hyperactivesw.com
> _______________________________________________
> 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