Making Revolution faster with really big arrays

[Robert Brenstein]

>I would not disregard this option so readily. You can use the 
>database as an array of sorts allowing you to pull out any set of 
>data you need to process and store the results there for later. If 
>you are concerned with performance of server-based databases like 
>PostgreSql, OpenBase, or MySql, you can try Valentina which embeds 
>directly into Rev and is renowed for its super fast performance. To 
>reduce disk access issues, get a good SCSI card and a fast SCSI 
>drive, giving you additional benefit of having data on a separate 
>physical device than your OS and your program.
>
>This solution would be more scalable and portable. It is quite 
>likely your data will grow faster than memory capabilities and 
>address space restrictions.
>
>Robert Brenstein


PS

Furthermore, array-based solutions will likely force you to use 
index-based loops whereas such an alternative solution may allow you 
to use repeat-for-each loops which are order of magnitude faster. 
That was probably a large portion of the slowness you observed.

Robert