What is the optimal average bufferpool read time in a multipartitioon datawarehouse?

LinkBack

Thread Tools

Display Modes

#1 (permalink)

04-29-2008, 08:26 PM

Posts: n/a

What is the optimal average bufferpool read time in a multipartitioon datawarehouse?

Hi,

What would be the optimal/good/average/bad average bufferpool read
times in a EEE data ware house environment?

Also, is the operation of sending data over tablequeue will have
affect because of high overall CPU I/O wait time? I was thinking it
should not because communication is all dont at the memory level.
Please correct me if i am wrong.

Thanks'
KC

« Re: Moving tables between an iSeries and DB2 for Linux | Commit Active »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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 Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT. The time now is 06:06 AM.

SEO

What is the optimal average bufferpool read time in a multipartitioon datawarehouse?