If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hm, one more thing. You say the data in box1 (the one with fewer disk reads) is the exported version of the data on box2. Is it possible that there has been many deletes in tables in box1 and that there are some full table scans occuring on those "sparse" tables? If this is the case then the same full table scan on table on box2 might cause thousands of disk reads, while on box1 it could scan it in only a couple of reads, because the data was "packed together" during import, so the HWM is set very low comparing to that of box2.

Jurij ModicASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?