And on, and on, until the particular bit of data is found. So... (this being one of the overwhelmingly elegant things about the Pickuverse) this means that in a properly sized hashed file NO MATTER HOW BIG it only takes one disk read to get to any record given a known key. Ask your local Oracle/Sybase/Informix/SQL Server DBA if they can do that. Stand back though, they tend to sputter alot.
But won't this only work if your data fits into the modulo that matches your page size? If your data is lumpy and doesn't nicely fit into the page size/file modulo selected you get level 1overflow and more disk IO. Looking forward, when USB sticks get big enough you can put all your data on one. No more disk reads and ultimate portability 8-) Adrian ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
