Post
Topic
Board Development & Technical Discussion
Re: PointsBuilder - fast CPU range points generator
by
kTimesG
on 30/04/2025, 07:18:24 UTC
But the question is what is structure of the database if its 1 file there is no advantage for lookup .
So they are stored randomly.

Well that much ram is expensive.

Oh well, if a searchable X-coordinate indexed structure such as the B*-tree of an SQLite 1-file only database has "no advantage for lookup", I don't really know what does. Maybe dumping into tens of thousands of text files and doing linear searches. That sounds ideal!

You're free to do what you want with the generated points though. Storing them all to disk is not exactly optimal, no matter how you do it. That's why maybe you should not do it at all, unless you want a 10.000x slowdown in general when planning to actually use the points without having all of them loaded in RAM.