INFORMIX-SE and databases

I recieved a few item from Informix describing the SE system, and I was wondering about databases: It says I can have only 1 database open at a time? That sounds like some limitation. I assume I can have as many tables (which are files, right?) open as I want? No limit of tables per database? Are there any perfomance considerations for putting all my tables in one database, even if they are unrelated? What is the overhead of opening a database? I assume I can do something like: open database select dataclose database open second_db select more data close second_db But that will take up alot of memory right? Load the whole of the first group, then the second. The way I would like to write it is to load one record (row?) from the DB, get more data from another table and then output it or whatever. For that, I'd need both tables in one database? -- Brian Simmons, Denver,Colorado,USA. - bsimmons@csn.org *On an Amiga!*