That's fine for a system like access or DBASE, but you should never be making
queries that large for
a production application.
Access or DBASE or any other local FILE based system will not have any problems
bringing back 1 million
records because it does not have to bring the records across the w
You give me valuable insight into the inner workings of such
software. I am a firm believer in testing everything with very large
files. One might spend months developing something, and have it in
production for a year, and not realize what will happen when their files
(tables) grow to sev
