Posted on: 2016-03-17 09:56:43.000Hi Jojo!
Lists are very efficient up to around 10,000-20,000 records. After that they get a bit slow and memory usage becomes an issue. My first project with newLISP was a database that had about 400,000 records, and I found that it was impossible to put all the data in lists and manage them at a reasonable speed.
Databases are a great way of getting around this limitation. The SQLite database used by Rockets is fast and reliable, and whenever you query it, you get the response back as a newlisp list, so it's all good!