12-15-2022, 12:26 PM
(12-15-2022, 11:51 AM)Pete Wrote: If this is per class, you might be dealing with 600 assignments * 20 students * 5 entries 60,000 lines of data. QB64 ...FOR BINARY can read a file of that size fast enough without the complexity of hashing or indexing. I have many around 40,000 that process just fine, but if you were to make a database for every student in the whole school for every school year for the next 20 years, you'd need more of the mySQL method.
Anyway. My advice would be to figure out what database format you want; a fixed block like the example above, or one with flexibility to add stuff as you go like the other example. Once you're settled on something, write a very small test database and post it if you have any questions.
I am reading/writing (csv) files of multiple GB in memory structures in just seconds by reading binary blocks of 4MB (fastest)
This can also be used for above formats if the file might grow huge.
Just let me know when you need that
45y and 2M lines of MBASIC>BASICA>QBASIC>QBX>QB64 experience