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


_______________________________________________
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

Reply via email to