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 _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
