Arrays instead of Sql

[viktoras d.]

Tom,

sort the data in variable instead of field using field only to display 
results, not for the data processing, or at least lock screen before 
sorting and then unlock screen. This will be much faster.

When putting data into field again lock screen and unlock afterwards. 
This will prevent field trying (slowwwly) to display its contents while 
these are being loaded into it.

Viktoras

Tom Cole wrote:
> I've heard that instead of using a backend like sql to manage a 
> database, I could stay in Revolution and use arrays. I know nothing of 
> arrays.
>
> I've written here before about a bird database I have. Several times. 
> Forgive.
>
> I just have a few items in a record: 
> birdname,birdnotes,place,placenotes,date  However, there are about 
> 18000 birds (records) and I've got them all in one field in Rev now 
> and it's too slow to sort.
>
> If I have to learn sql and so on, this may never get done, but if I 
> stay in my familiar Rev environment I will be off and running. Is 
> there a sample database stack where someone has used arrays to store 
> the data for fast retrieval or some related script to help me learn 
> how arrays could be used?
>
> How can I place those records in arrays and then draw data to make 
> cool sorts and views?  I'm not new at all to Rev; only to arrays.
>
> I just need ideas on how to sort the data fast.
>
> Thanks (again!)
> Tom in Arizona
> _______________________________________________
> 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
>