Well most of the big spans would be done in the set-up process (by me) 99.99% of the time the end user would only span one letter "AAAAAAA" thru "AAAAAAZ" thats a maxamum of only 26 records
Reason it's going to be mostly smaller spans is that most people can't / shouldn't store 8 billion eaches of any stock item, ya know
and yes if you add 8 billion records the preview mode would be so much information it would confuse the end user, but kinda like what I said, most users will add far less records
I guess my question is, am I tring to make my program to powerfull?
>>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?