Re: Informix handling VLDBs

SLIP User (tmyers@news.epix.net) wrote: : I am interested in any experiences of the use of Informix in Very Large : Database projects. I am currently involved in a project which will need : to hold in excess of 100million rows of data. This data will need to be : accessed and retrieved as if it were all in one table, that is, we will : need to select a record from this data based upon phone number, unique : id, user name, address etc. : Anyway, I am in search of experience in the use of VLDBs in Informix, or : any other platforms for that matter. Any help would be greatly helpful. : Since we are still in the evaluation stage, any contacts with relevant : experience would be appreciated. I need to know how the rest of the : world has delt with similar problems... Thanks in advance. HCIA currently administers over 300GB in Online 5.x on Sun servers. We were going to migrate to 6.x, but have decided to skip it and wait for 7.x, which we perceive to be the answer to our problems. Our largest table has about 60 million rows. We have many, many tables in the 2 million to 20 million row range. Mike Reed, HCIA, Ann Arbor, MI (313)930-7943 mreed@hcia.com