Author

Message

jojo

Posts: 20

Posted on: 2016-01-26 21:35:44.000

Hi and thanks Rocketman !

Is the database a better option because it scales to a greater number of records?

Thanks and just curious why no to use nL lists to keep records. Rockets is the best thing around!

Very much appreciated for what you've put together with nL! Greatest potential out there! Thanks!

Rocket Man

Posts: 383

Posted on: 2016-03-17 09:56:43.000

Hi 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!

jojo

Posts: 20

Posted on: 2017-03-10 00:14:15.000

Super cool! Thanks for the clarification!