RE: Q: Informix & Large Unix password files

??? writes: >I am developing an application using Informix 4.12 on a Unix box where >the potential number of users could exceed 50,000, but only a couple >hundred would be accessing at any one time. >During testing, it was determined that having a "LARGE UNIX PASSWORD" >file resulted in unbelievable response time when logging into Informix. >When accessing informix, an informix deamon process calls upon the >native operating system, in this case unix, to read the unix password >file for verification (reading it sequentially). Since the application >will need to support such a large number of potential users, the large >password file is a necessity. Unfortunately, the response time for >user verification is unnacceptable. >Any ideas speed this process would be greatly appreciated!!! How about editing the passwd file so that all the informix users end up at the top of the list? Since it is read sequentially, informix will find what it wants quite quickly. You then only need to figure out a way to automate this (if it works)! Mark Denham BBC London, UK Mark.Denham@bbc.co.uk