Spectate knows that Sometimes sequential is faster
@PotatoEngineer
They blocked me for being too smart.. That has got to be it.
I had so much knowledge to share about sequential and binary search / indexed search...
When doing cablesystem and telco conversions the master files would have 50,000 or more customers.
The data would come in sequential files and need to be moved to the new customer formats..
NOTE
When you add 1 record at a time to a indexed format.... It is slow... very slow
If you have more than 1 key to add, that slows things down even more.
Same thing when you update multi keyed records.. slowdom happens.
So
On the initial build of the subscriber file... I'd put the data to a sequential file.. (fast)
Then do a convert of that to indexed format .... Using just one key so it was relatively fast.
The one key was the subscriber number.
The subscriber record got updated with a number of passes... as an indexed...
Then when the changes were done...
I'd do a convert from indexed back to sequential.. very fast
Then convert that sequential to indexed with all the keys... subscriber#, phone#, address, etc.
This was considerably faster than doing 1 change at a time in a multi indexed / keyed file
The conversion runs would have taken a day or 2 compared to maybe 3 or 4 hours.
Sometimes you have to be a pushy braggart to share...
I'll share more about throwing Skip rocks not skipping rocks.
I was the best and my Swampies will rule the curling world shortly.
When you do things totally different you get some surprises.
Curlers beware.
Too bad for those site members that BLOCK old Spectate.