Adrian Merrall wrote on 10/17/2006 06:44:40 PM: > 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.
Good point. And in case anybody is still thinking of setting up files with modulo 1 to improve performance, remember that UniVerse will associate all records in that file with a single lock semaphore, creating a potential bottleneck on the lock table. Tim Snyder Consulting I/T Specialist U2 Consulting North American Lab Services IBM Software Group ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
