We were using Baan4c2 with 20 users and recently increased to 30 users. The system has slowed down considerably and the users are complaining. We have about 3.6 million records in integration table after archiving 3 years of data (1998-2000).
The maintain receipts, invoice matching and posting are very slow. Our database is Informix and it is in raw device. Our full backup is 3 tapes (4Gb compressed to 8GB per tape) and took about 6 hours to backup. Our processor is 180 Mhz and memory of 1 Gb.

We are thinking of moving to a faster machine using SQL Server as the database. What configuration would you suggest. We have been using HP system for a long time and we would prefer a HP model. We are in the manufacturing sector making car stereos, etc.

Your input is greatly appreciated.
TQ.

Hi TQ,

If you already mastered HP-Ux, then I wouldn't switch to any Windows based system. Nothing to gain here.

For 30 users, just exchange your current system with an HP A-class server with 2 CPU (750 Mhz). It sounds like a DDS-4 DAT drive would be enough for your backup, which uis the smallest available nowadays anyway.

Most likely considering your HW support cost, the new A-class will cost the same and gets support for some years included.

Just my personal opinion, of course. Also just my opinion: throw away informix and get oracle.

Regards

Markus

Your own PC has probably more than 500 MHz and it is a single user machine... 180 / 30 MHz ... that is 6 Mhz / user ...:-) I know, it is not right to think like that.

Search this board for more opinions on replacing Unix for M$... also my opinion: stick to Unix.