Hi LeRoi Two area you could consider.
Resource conflict ------------------ Are you using a multiple CPU box. If you are using a dual CPU box then each CPU could be processing a list, where 10 parts could be competing for each cpu time. The other issue is if the multiple part files are on the same disk drive, then they are competing, if you run 10 parts on 10 separate disks you would likely to receive different results. With release 10.1 the select statements take advantage of hyperthreading. If you are going to do publish/suscribe, then the performance may differ again between 2 parts and 10 parts. The file types can be an issue. -------------------------------- When splitting the file into 10 parts, the keys become more similar and you would probably need a very different file type to a 2 part file. Eg if you had a 9 digit key with 2 parts, part 1 keys could start with numbers from 1-5 and part 2 key could be numbers from 6-0 With 10 parts, part 1 would all start with 1s, part 2 would all start with 2s, part 3 would all start with 3s, etc. If you use the same file type for 2 parts, as 10 parts, then you would get greater overflow in the 10 part file. The 10 part would work better with a file type that works from right to left in this case. Would be interested to hear your results on this Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business & Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418 8329 Fax 61 2 9427 2371 www.dacono.com.au ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
