On Mon, 23 Sep 2002 15:09:06 +0100, "Niall Litchfield"
<n-litchfield_at_audit-commission.gov.uk> wrote:
>"Ed Stevens" <spamdump_at_nospam.noway.nohow> wrote in message
>news:3d8f1097.20917417_at_ausnews.austin.ibm.com...
>> On Sun, 22 Sep 2002 20:41:11 +0100, "Paul Brewer"
><paul_at_paul.brewers.org.uk>
>> wrote:
>>
>> <snip previous quotes>
>>
>> >Ed,
>> >
>> >Can't you put all the logic in a stored procedure, and call the SP from
>your
>> >COBOL program?
>> >That way you'd eliminate concurrency issues, as well as improving
>> >performance, and reducing the number of lines of code.
>> >
>> >Paul
>> >
>> >
>> In an ideal world, probably so. However this project is to port the app
>to a
>> new platform (going from OS/2 and DB2/2 to NT and Oracle), and has very
>high
>> visibility, so they are trying to minimize the amount of re-engineering.
>
>Hope that doesn't mean they expect a performance improvement as well :(
>
>
>--
>Niall Litchfield
>Oracle DBA
>Audit Commission UK
>*****************************************
>Please include version and platform
>and SQL where applicable
>It makes life easier and increases the
>likelihood of a good answer
>
>******************************************
>
>
Oh, that's the easy part. The app and db are currently hosted together on
256mb, 66mhz machine. The hardware upgrade alone practically guarantees a
performance boost, unless the new TP monitor gets in the way.
--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)
Received on Mon Sep 23 2002 - 14:52:33 CDT
