dbTalk Databases Forums  

Performance Question - Loading of Database and LTAPEDEV

comp.databases.informix comp.databases.informix


Discuss Performance Question - Loading of Database and LTAPEDEV in the comp.databases.informix forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
cpeek@hcso.tampa.fl.us
 
Posts: n/a

Default Performance Question - Loading of Database and LTAPEDEV - 07-30-2007 , 07:26 PM






I have a question regarding LTAPEDEV being set to /dev/null and
performance, and will not have a chance to test until tomorrow.

During a mass load process, will having LTAPEDEV set to /dev/null
increase performance significantly over having LTAPEDEV go to a disk
file backup triggered using ALARMPROGRAM set to the standard
log_full.sh script?

I would in no way leave this setting in a production, but we are
seeing a significant difference between a high end pSeries server (4
processor, 8GB) and a low end Linux server (1 processor, 1GB) with
similar onconfigs. The one setting that stands out is LTAPEDEV being
set to /dev/null.


Reply With Quote
  #2  
Old   
Obnoxio The Clown
 
Posts: n/a

Default Re: Performance Question - Loading of Database and LTAPEDEV - 07-30-2007 , 07:43 PM







cpeek (AT) hcso (DOT) tampa.fl.us said:
Quote:
I have a question regarding LTAPEDEV being set to /dev/null and
performance, and will not have a chance to test until tomorrow.

During a mass load process, will having LTAPEDEV set to /dev/null
increase performance significantly over having LTAPEDEV go to a disk
file backup triggered using ALARMPROGRAM set to the standard
log_full.sh script?
Yes.

--
Bye now,
Obnoxio

"I'm astonished anyone pays real money for this crap."
-- Cosmo

"Cluster in my trousers"
-- Guy Bowerman

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.



Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.