>a. I should use a table to store the results, right?
I've worked with large-loop processing -
First, a table has a 1 billion record limit, so you'll get stuck right there unless you split it up. At that point you might as well mot worry about number of loops, since you'll need to split it up. I've had some very large FOR loops, but there might be a 2,147,483,647 limit, not sure. Easy to test in an hour or so (just a guess on time, depends on machine), on an empty FOR loop.
>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?
Second, I think you'll have memory/display/performance problems at that level, but perhaps more importantly, it's going to be very difficult for users to constructively use such an interface, isn't it? Can't you "weed out" only a few desirable "words" to output, something like that? Maybe limit the scope of the user selections?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.