high number of databases
Posted in 2003
rkusenet — — source: IIUG Forums & Mailing Lists
We have multiple databases in our system. To keep it short, we have one database per client. At present we have 35 databases. Very few tables are same for all clients and those tables are in a single database, with views created for them in each individual databases. The rest is seperate for each client I have been informed that now I may be creating new databases more frequently than before. Assuming I create 3 per month, I am beginning to wonder whether Informix will crap out after some time. Has anyone prior experience in maintaining large number of databases. Any problems. TIA. ravi