IQ is optimized for queries (SELECTs) because it allow for an efficient method of having all coumns indexed. Part of that method is a data compresion scheme. These things together make SELECTs quite fast but INSERTs and UPDATEs quite slow. SO for a decision support app where you load data once (or infrequently) in bulk and SELECT many times it works great, For a traditional OLTP app with much INSERTing and UPDATEing the overhead would become too much.
Lots of thanks for the informative reply. Currently I'm involved in the development of an application that is comprised from two modules: 1) a data entry module and 2) a reporting module. I think the reporting module is actually a decision support system as its purpose it to let the top level managers to perform complex queries over the entered data and then take decisions based on the results of those queries.
Data is entered by operators (less than 500 operators use the system) and at most each operator may enter 50 forms per day. And then managers query against these available information for decision making.
I think IQ would be a perfect fit for this application and Also 25,000 inserts/updates per day does not look to be a problem isn't it?
BTW - Does IQ perform the automizations automatically or does it require extensive manual tweaking?
Last edited by behrangsa; 11-20-04 at 11:02.