Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
WOW, it's mindblowing to me
Message
From
21/12/2000 13:23:55
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00455962
Message ID:
00456010
Views:
25
>I am working on a letter incrementing utility AKA A,B,C but with a 7 character field AKA AAAAAAA, AAAAAAB, AAAAAAC. So this procedure could have to loop up to 8,031,810,176 times, yea thats 8 billion times
>
>End users will just enter the starting letter / ending letter series and I want to figure out the rest
>
>My question / observation is
>
>a. I should use a table to store the results, right?
>
>b. I think I will have problems displaying the results, does anyone know if a object (Grid / Listbox / whatever) that can handle 8 billion records without a increased chance of my program or the PC bombing?

The biggest problem I see is that all that data is going to take memory. Assuming you start at AAAAAAA and go up to ZZZZZZZ, it will take 8,031,810,176 x 8 bytes = 64,254,481,408 bytes = 64Gb of memory. Consider that VFP tables can hold 2Gb. And you'll also need that 64GB (not MB) memory to show that up! :)

I hope you have really big PCs... :)
Sylvain Demers
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform