To your final point, I admit we're all guilty of just throwing money at
hardware than a completely re-engineering an inefficient application.
The same argument is true of the many and varied MPE and VIEW emulators
- it must be better in the long term to re-engineer your applications to
modern technolgies, but for now, I'm sticking with an emulation
approach. Many would and could argue I'm contradicting myself !
It's probably been said before, but the biggest challenge facing HP3000
sites on migration is the move towards a tiered architecture -
especially the smaller sites with tiny budgets.
-----Original Message-----
From: Charles Finley [mailto:[log in to unmask]]
Sent: 03 March 2006 16:51
To: Tony Summers; [log in to unmask]
Subject: RE: Migration recommendations; PRELIMINARY INQUIRY
Tony Summers wrote:
"I assume all vendors of such tools would be prepared to publish how
fast their software is at delivering data back to the calling
application.
:)
Let me guess the answer ... "It depends".
The fundamental point is .... that trying to use Cursors on a RDMBS will
never give you the performance you can get from native SQL approach.
Indeed most books on SQL, including M$soft SQL advise against this
approach. "
I agree with you Tony. However, I would suggest that in the contexts we
have experienced the above does not matter.
1) Customers don't seem to care about theoretical relative performance
numbers, all they seem to care about is that the can achieve what they
think of as acceptable performance for THEIR applications. All of our
customers seem to have clear ideas about that and they put that
expectation in contracts. We meet those contractual obligations.
2) As I mentioned previously, fast machines are really inexpensive
today.
Therefore, if a customer can achieve the performance they feel they need
for their application and the hardware is really cheap, why would one
care about relative performance of pure SQL access versus cursor based
access?
3) It is more expensive in terms of labor costs to redesign your
application to perform faster. For example, a migration that cost
$100,000 going the simple route using cursors, could conceivably cost
as $300-$500,000 with a redesign! Moreover, any redesign is more risky
than a simple migration.
Customers who like our approach are first and foremost risk averse.
Secondly, I think it is difficult today to find a customer who will
spend $200,000 in labor to avoid spending an extra $10,000 on hardware.
Charles Finley
619-795-0720
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
The contents of this email are confidential to the intended recipient
and may not be disclosed. Although it is believed that this email and
any attachments are virus free, it is the responsibility of the recipient to confirm this.
Smith & Williamson Corporate Finance Limited - A member of the London Stock Exchange.
A member of M&A International Inc. http://www.mergers.net Registered in England No. 4533970. Authorised and regulated by the Financial Services Authority
Smith & Williamson Investment Management Limited, Registered No. 976145. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Pension Consultancy Limited - Independent Intermediary. Registered No. 3133226. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Fund Administration Limited, Registered No. 1934644. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Limited - A member of Nexia International. Registered in England No. 4534022. Regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.
NCL Investments Limited, Registered No. 1913794.
Member of the London Stock Exchange authorised and regulated by the Financial Services Authority.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.smith.williamson.co.uk
Nexia Audit Limited - A member of Nexia International. Registered in
England No. 4469576. Registered to carry on audit work and regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.nexiaaudit.co.uk
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
