Re: Informix and large databases

Robert Lada <rllalex@mediaone.net> writes: > Our question is two-fold: > > 1. Does Informix support some kind of "batch" updating that would allow > us to update single fields from a staging table without dividing the > transaction into parts, and without carrying the overhead of logging? > The update would look something like > > Update master_table > Set master_table.my_field = trans_table.update_field > where master_table.key = trans_table.key Sounds like a batch load kind of deal. This is definitely supported in the product that I work on, which is IDS with the Advanced Decision Support Option (called IDS/AD or IDS/ADSO). > 2. Our server has 6 cpu's. Does Informix take advantage of multiple > cpu's when processing queries, or during initial data loads? This is something specifically for which the product (mentioned above) I work on is developed. > We function much more as a data warehouse than as an OLTP system. There > are no "real-time" updates in our system, though we support multiple > concurrent queries. I think you would be very happy with IDS/AD. --jrp