Hi
I am sorry. I cant't English well.
I want to know something.
May I ask you a question?
My system is a Linuxbox which is Redhat 5.0( Pentium 133MHz 80Mbyte Ram 120Mbyte Swap Memory) and
Redhat 5.0)Pentium 160MHz 16Mbyte Ram 60Mbyte Swap Memory).
I Install PostgrSQL 6.3.1.
And I Install Int8 program, becuase data is greater then 5000000000(signed)
I create table. like below
create table lr(
rec_cd char(2),
actl_sect char(4),
magam_ymd char(6),
actl_hq char(2),
actl_dept char(4),
aip_cd char(1),
cd char(2),
bj char(2),
val int8[][][],
primary key(rec_cd,actl_sect,magam_ymd,aip_cd,cd,bj)
);
Array val is [6][6][6] demension.
Count(lr) is 33000 and. after time more then 1000000 record.
I test query
select lr.val[1][6][6] from lr where
rec_cd='1' and actl_sect='9' and magam_ymd='199802' and aip_cd='1'
and cd='MM' and bj='BT';
but result time is 30secend. Late!!!
Why? I am bl
ue....
Help me Please.
