Reply to: Daily 'no, seriously dude, wtf'?

[darmstadt]

I expect the SQL Server 2000 machine cost a lot less than the mainframe!

TCA / TCO anyone ?

Can't be bothered getting the figures but on my mainframe I can run hundreds of OS'es and each one running a database appliction (DB2, MySQL, Oracle, whatever) I think you'll find in the end that the mainframe will be cheaper to maintain...

[Platypus]

For some extra context re. 100 records per minute, as it happens I loaded a table into a mainframe test database just before lunch, 2.1 million 217 column records in 18.5 minutes.

Not particularly quick compared to the Linux machine cited, admittedly.

The same data, transformed into csv format, loads on SQL Servers running SQL Server 2000, on live servers also handling normal daytime load, in about 45 minutes.

I expect the SQL Server 2000 machine cost a lot less than the mainframe!

TCA / TCO anyone ?

[IR35 Avoider]

For some extra context re. 100 records per minute, as it happens I loaded a table into a mainframe test database just before lunch, 2.1 million 217 column records in 18.5 minutes.

Not particularly quick compared to the Linux machine cited, admittedly.

The same data, transformed into csv format, loads on SQL Servers running SQL Server 2000, on live servers also handling normal daytime load, in about 45 minutes.

[stek]

A little secret, Windows or Linux, if you're using Intel Processors you're still going to hit latency issues...

POWER7, Micropartitioning and DLPAR, it's the future, like Garlic Bread.

[DodgyAgent]

A little secret, Windows or Linux, if you're using Intel Processors you're still going to hit latency issues...

You clever little permie you

[SupremeSpod]

One of my clients has shifted all the servers to linux - this means more money can be spent on the hardware, resulting in beefier machines. 50 million records loaded in a few minutes. That was quite impressive.

A little secret, Windows or Linux, if you're using Intel Processors you're still going to hit latency issues...

[NotAllThere]

One of my clients has shifted all the servers to linux - this means more money can be spent on the hardware, resulting in beefier machines. 50 million records loaded in a few minutes. That was quite impressive.

[Mich the Tester]

I've never worked anywhere like that Mich. You just pick bad clients... or perhaps it's the case that if it wasn't for safety-paranoid companies, you'd be out of a job!

No, I'm at a decent client now; it's not a huge company, just about 200 people so it isn't infected with manageritis just yet. I've been to a few crap ones though.

[BrilloPad]

WRONG!

Sorry BP, but I have to fundamentally disagree with you there. CPUs SHOULD be cheaper than coders, but they aren't because adding a cpu involves making formal requests, countersigned by a director, to the bloated purchasing department, then having the request denied because you haven't filled in part III section b, subsection iv of the ISO9000 purchasing request form, which means you have to fill in a new form, get it countersigned by a director and approved by the compliance officer who's having a day off for his 'elf and safety course, then awaiting purchasing to send you confirmation, then waiting for the preferred supplier to deliver according to their SLA, which states that said CPU will be delivered within 6 weeks (in other words, in 6 weeks) of receipt of countersigned and compliance stamped order form. Then said CPU waits around in a mysterious postage holding centre known only to the purchasing people, and eventually, after nobody's been able to do any work for 6 weeks, well you know what I mean. Somebody with an MBA has ensured that CPUs are expensive.

All fair comment. But don't you have to do the same thing for coders these days?

I am so pleased I am at a hedge fund these days. Walk round to see hardware purchaser. Chat about his fitness regime. Ask for what I want. Get it a couple of days later.

[d000hg]

I've never worked anywhere like that Mich. You just pick bad clients... or perhaps it's the case that if it wasn't for safety-paranoid companies, you'd be out of a job!

[Mich the Tester]

Recently I was working at an IB in London and they spent thousands of hours coding time trying to improve their overnight batch. I think they reduced it from 9 hours to 8 hours. Then someone realized that the database was running on 10 year old cpus - just replacing them reduced to 4 hours.

cpus are cheaper than coders.

WRONG!

Sorry BP, but I have to fundamentally disagree with you there. CPUs SHOULD be cheaper than coders, but they aren't because adding a cpu involves making formal requests, countersigned by a director, to the bloated purchasing department, then having the request denied because you haven't filled in part III section b, subsection iv of the ISO9000 purchasing request form, which means you have to fill in a new form, get it countersigned by a director and approved by the compliance officer who's having a day off for his 'elf and safety course, then awaiting purchasing to send you confirmation, then waiting for the preferred supplier to deliver according to their SLA, which states that said CPU will be delivered within 6 weeks (in other words, in 6 weeks) of receipt of countersigned and compliance stamped order form. Then said CPU waits around in a mysterious postage holding centre known only to the purchasing people, and eventually, after nobody's been able to do any work for 6 weeks, well you know what I mean. Somebody with an MBA has ensured that CPUs are expensive.

[suityou01]

Why are you not running systems in parallel?

MF in 'Director' Mode.

It is an option.

1000 a minute? What are you running? A ZX Spectrum?

Tell them to buy a nice big mainframe. It's what they're built for.

Don't diss the speccy man .

You really took control of that situation and used your experience and knowledge to resolve the issue.

Thanks

The system isnt Epicor's Vantage, by any chance?

No

FTFY

Well it rhymes with crap.

Is it VMware on a glorified PC?

Yup

[Bunk]

Suity, in "saving the world, one project at a time" mode

[teclo]

Let's give it more memory and bigger ram!

[BrilloPad]

Recently I was working at an IB in London and they spent thousands of hours coding time trying to improve their overnight batch. I think they reduced it from 9 hours to 8 hours. Then someone realized that the database was running on 10 year old cpus - just replacing them reduced to 4 hours.

cpus are cheaper than coders.