Re: Q: Informix & Large Unix password files

Dave McConnell (mcconnel@ix.netcom.com) wrote: : 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!!! IMHO, it's rather difficult to mantain 50,000 Unix users. Maybe, you can replace them with only 2 ? First user ID can be used to log in to unix. It has no rights granted on the database. (And, maybe, no password) It can only run application with SUID to second user. Second user has some rights on database, and application must perform their own authentication. If user names and encrypted passwords are stored in the indexed table, access time can be more acceptable. WBR, Vadim J. Nikitin