How can I get throughput of informix such as how many query/update operations per second?

Posted in 2007

eagle_jyjh@citiz.net — 3 Jan 2007 02:09:30 -0800 — source: Usenet: comp.databases.informix

Given an database, how can I get the throughput of informix ? such as how many query/update opertions per seconds informx can support? Because my application may submit serveral thousands of database operations per seconds, I want to calculate how many prcocess of my application can be started.

↪ replying to eagle_jyjh@citiz.net

Zachi — 3 Jan 2007 05:28:43 -0800 — source: Usenet: comp.databases.informix

eagle_jyjh@citiz.net wrote: > Given an database, how can I get the throughput of informix ? > such as how many query/update opertions per seconds informx can > support? > Because my application may submit serveral thousands of database > operations per seconds, > I want to calculate how many prcocess of my application can be started. The short answer is: "that depends". The longer answer is: That depends on: your server hardware: CPU performance number of CPUs amount and speed of memory storage system bandwidth your storage system: I/O bandwidth cache size disk rotational speed number of disks your application: the exact queries (OLTP or DSS) size of transactions and result sets size of tables and indices query optimization (indices and directives) database version use of replication (HDR and/or CDR) your database layout: logs placement tables and indices placement fragmentation scheme appropriate statistics gathering and probably a few (many?) more factors that escape me at the moment. Whole books were written on the subject - there isn't an easy answer. Zachi