Informix : Poor performance

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by Mikah 0n 29 December 2008

I’ve got some problems with my db server for two weeks. It is used as a report server, data are imported nightly from production server in form of packed dbschema and flat unl files thru ftp , simple script creates sctructure, load data, then create indexes, trggers, etc. update statistics, at the end drop old db replacing new one, it took about 6hours, now it take over 21!!!.
I’ve checked hardware and software and I haven’t found any problems,
except one in online.log – “VPCLASS ‘cpu’ not enough physical procs for affinity” (qnty of cpu not changed!!!), so I’ve tried to tune onconfig, it succeeded to me to go down below 10 hours with all dbimport, but i have no idea what do next.

Learn more about informix databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting