List db scalability

Forum post


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: 382
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!

Posts: 20
Posted on: 2017-03-10 00:14:15.000
Super cool! Thanks for the clarification!

Views: 2310