Big tables

[Kogan, Arthur]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01BE74B4.16AB32AA
Content-Type: text/plain

Hi Lynden.

QTP does have a lot of overheads and therefore is by far not the fastest
tool. The advantage of QTP is in easy maintainability, but at the expence of
performance. We had experience of large and simple updates on DG AOS/VS
against DG/SQL. In our tests COBOL program, although about 10 times the size
in terms of source code, run 10 times faster than QTP doing the same thing,
in our case QTP took 20 hours, COBOL 2 hours. As we could not afford 20
hours (and the update was quite simple), we decided to use COBOL. My view is
you use whatever tool solves your problem best.

Regards,

Arthur Kogan
Westpac Financial Services
Sydney, Australia 

> -----Original Message-----
> From:	l.dyer@mgn.co.uk [SMTP:l.dyer@mgn.co.uk]
> Sent:	Tuesday, 23 March 1999 12:46 AM
> To:	powerh-l@lists.swau.edu
> Subject:	Big tables
> 
> 
> 
> 
> We have an Rdb database on VMS (Powerhouse 710g1) that contains only one
> table. This table contains some 48,000,000 records which we wish to update
> in a timely fashion.
> 
> We have dropped all the indexes and are proceeding to update with QTP.
> 
> We obviously have the option of running an SQL script if necessary.
> 
> I realise that we can use RMU to create a flat file which we can update
> and
> reload, but I am not sure that this will significantly reduce running
> time.
> 
> Does anyone have any comments on the above alternatives or any other
> methods that may significantky reduce update time.
> 
> Lynden
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

------_=_NextPart_000_01BE74B4.16AB32AA
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IgYWAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAPAAAAUkU6IEJpZyB0YWJsZXMAngQBCYABACEAAAAyNTlE
OEJBQkE0RTBEMjExODg0RTAwMDA4MzY4MzU2NwD6BgEggAMADgAAAM8HAwAXAAkAIgADAAIAIAEB
BYADAA4AAADPBwMAFwAJAB0AFAACACwBAQ2ABAACAAAAAgACAAEDkAYAnAoAACsAAAALAAIAAQAA
AAMALgAAAAAAQAA5ACC8Dm6zdL4BHgBwAAEAAAALAAAAQmlnIHRhYmxlcwAAAgFxAAEAAAAbAAAA
Ab50ayneZV6PS+AeEdKeHgAA9rj6EQARyaZwAAIBCRABAAAA0gUAAM4FAAA9CQAATFpGdYaNVvMD
AAoAcmNwZzEyNdIyAPszNgHoIAKkA+MJAgBjaArAc2V0MB4gBxMCgwBQEFZwcnHeMhFZDlAD1RFl
fQqACMjsIDsJbw4wNRV/CmACgNkKgXVjAFALA2MAQQtgIm4OEDAzMwumIEggaSBMeW4BAG4uBwqi
CoQKgFFUUCBkBm8HkRDgdmUgYSAzCQAFQG9mHLAcMHJoGGVhZAQgAHBkIHQvHTAW4AIQFuAgBAAg
Yuh5IGYKwW4ckR3RHsEsc3QHkB8xbwbwLiC2VB9hHVB2AHABkGccQK8cwRuCHnELgCAdQHMesD8A
wAuAAZALgAGgAxBpdFR5LB6QdQVAYR80ZbR4cAnwYyEzJFByHiH3A4EkgCBQVxxAEOAdsCQydwiB
JHULYHIhIR2SAJBt4wtQHEB1cGQjwAeRAiAIIERHEVBPUy9WHwXwIRALcR/hKMAvU1H6TCBQSQOg
CGEdwB/RBCDgQ09CT0wk0ANgCcA8YW0jYAdAHdAIYGdo/xxQBuAjkRlQHcAHcx9SAJB+eh5RA6Af
wCUwKHEc0HOfCGEkgQWgAQAjYHJ1A6B/LRcfkyqxEOADoBuEC4Bn/y2UK+AcQB3QMbEjYCHxKpKe
Yx+gHEAbgiARayAZ8X8sUREAI2ArNBLQNHMgUEFlBCB3L0J1bB2wHxJhzwEgBbAdsDRGICgdlSgF
4zXwH6AgcXUjMC3CJ8JuKSNgNgEFgWkBAB2xb68oADOBKzMgUE0esHYIkNsH4B5xeQhgOtN3EOAf
wPcdASADLuFsHDA8IwXAK5E5AmBlbR6QH9Eau1JlfylwCyA0sBrKBxAd0CqhSz8rsABwGsQlsB+w
CrBjIP5GItEkcAcxBlI7wCSAEKCjGtMGsGRuZSNRQTrg/nQr0CMgHGAaygr0IyAPMU8YwQFAK5Ef
wGN0EeQxqDYgLUgyTwUQZyLR/QMgTQeQMjAhIEgzGsZHRAdHEQsTR0ZpLTE0NOMBQCMgMTgwAUAM
0EvT1mJCwANhOgyDYhFAIEDEZHkEkEBtZxqgBaBELnU0IFtTTRuQOn1N/l0axU0ABmACME1nVM0K
UHMoMCNRMjMF0ArAGxDQLQA5UwAtADI6NElIEEFNUHdUb01ncMZvNgAdIC1sQCMgKvHiLgPgYXUu
CYAMcFCH2HViakdxTWdCSKAdwP8BoCfgQ+VKP0dURpQM0AHB/xjBE5ETkgwBRY0bBiWzHDL5A6BS
ZE0AKDEBoDNyKJFyVgXhKFBVEwhgM4E3+xlQDhApMPIFQAWgIqMocvZsHrACIGUaxFhDIFIecY9Y
Q2DILvAyUTQ4LExg/jBkYi+wBZIdYTzADeAskP82AQPxLJA6sigjGsQh8Rxgfy1CYYEfkTKQAiAa
u11mZP0DYHAkUB2wB0ADIB9SC4D9AQB4B5EdkgrAHEArkSSA/wmAMbNmZmXxHdAhcmh+PoD/O8Bf
wWGBHBMfUmngLUAokf8cwS/BAwAxwQORKhEnkAUETwaQHwAFkEkicnkau0l/ZOFFITOBYIM2AgOR
OuJSfE1VOqIFAB1AOKEcYGb/C2AFQEugJ+Fld3RzOHQdkf8axBbgCQAdUCNkc1Ar4B8D/nMIcHPV
MoE14QMQPYFIoPcDAEugdHF0YYEW4RhAHED3cGYtQhq7RBvSAHA8QESA912GHrAFoG0HgAIwKHMf
Ut8ssRwyLDAEkSPAaT3SBbH/fuIckB3hGsQHgCxBHWFgg/cAwB6wevlre7c4ZXzPGlTxXE8KPSCH
34jvif+LDx+Lc0P1VxAE8j7gOiAi93mwjQVU9yIh4geBSUIekG8EcB6wOrEAwGo3AQNwb/tVjxri
VQCAjPkv0I2vjrz/j+9V3lUPVhQeYilwH8A40PdOIB2wYbEtmOE6oiMAPxD7lbNDgS6W9hrEYrOV
sh5i/mMJABEQeLFBUS2BOsCW8N8f4x9DlbIjYDxCbUThPtFbHFGS93IatRSRAKDAAAADAP0/UgMA
AB4AQhABAAAAKgAAADw4MDI1NjczQy4wMDRCOUIzOC4wMEBtZ25tYWlsMy5tZ24uY28udWs+AAAA
CwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAeACCAGAAAAAADAAAAAAAAARgAAAAAQ
hQAAAAAAAAMAI4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAB0EAAAHgAkgAggBgAAAAAAwAAAAAAA
AEYAAAAAVIUAAAEAAAAFAAAAOC4wMgAAAAADAA+ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAA
AAsAKYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAMgAggBgAAAAAAwAAAAAAAAEYAAAAA
EYUAAAAAAAADACuACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AOoAIIAYAAAAAAMAAAAAA
AABGAAAAADaFAAABAAAAAQAAAAAAAAAeADuACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEA
AAAAAAAAHgA8gAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAMAJgAAAAAAAwA2
AAAAAAAeADFAAQAAAA8AAABLT0dBTkE0RENCNzgzOAAAAwAaQAAAAAAeADBAAQAAAA8AAABLT0dB
TkE0RENCNzgzOAAAAwAZQAAAAAADAIAQ/////wIB+T8BAAAAYgAAAAAAAADcp0DIwEIQGrS5CAAr
L+GCAQAAAAYAAAAvTz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NOPU1TTUFJTCBBRERS
RVNTRVMvQ049S09HQU5BNERDQjc4MzgAAAAeAPg/AQAAAA4AAABLb2dhbiwgQXJ0aHVyAAAAHgA4
QAEAAAAPAAAAS09HQU5BNERDQjc4MzgAAAIB+z8BAAAAYgAAAAAAAADcp0DIwEIQGrS5CAArL+GC
AQAAAAYAAAAvTz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NOPU1TTUFJTCBBRERSRVNT
RVMvQ049S09HQU5BNERDQjc4MzgAAAAeAPo/AQAAAA4AAABLb2dhbiwgQXJ0aHVyAAAAHgA5QAEA
AAAPAAAAS09HQU5BNERDQjc4MzgAAEAABzCADjBQsnS+AUAACDCqMqsWtHS+AR4APQABAAAABQAA
AFJFOiAAAAAAHgAdDgEAAAALAAAAQmlnIHRhYmxlcwAACwApAAAAAAALACMAAAAAAAMABhAgQlom
AwAHEI4FAAADABAQAAAAAAMAERABAAAAHgAIEAEAAABlAAAASElMWU5ERU5RVFBET0VTSEFWRUFM
T1RPRk9WRVJIRUFEU0FORFRIRVJFRk9SRUlTQllGQVJOT1RUSEVGQVNURVNUVE9PTFRIRUFEVkFO
VEFHRU9GUVRQSVNJTkVBU1lNQUlOVAAAAAA0xQ==

------_=_NextPart_000_01BE74B4.16AB32AA--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.