Thread: Is cache disable ???
I am working in one of the biggest bank in Poland. We trying to choose platform for one of datawarehouse apps. We're just decided to work with Linux, but we need good rdbms system.
1) We build db with amount of 100MB of data. It is one table with 4 fields: 3 numeric, 1 datetime. We've created indexes on all 4 fields and we trying with statement SELECT * from maindat WHERE knd01=1928372 AND org01=200 AND date=... etc.
We got about 5 times slower performance with compare to MS SQL 7.0.
What'a the reason I could not see much difference working with or without indexes.
2) After submiting the same statement (eg 10 times) there was no cache. What's the reason.
Thank you for your help...
Adam Michalunio
"Adam Michalunio - ONET.PL" <amichalu@poczta.onet.pl> writes:
> 1) We build db with amount of 100MB of data. It is one table with 4 fields:=
> 3 numeric, 1 datetime. We've created indexes on all 4 fields and we trying=
> with statement SELECT * from maindat WHERE knd01=3D1928372 AND org01=3D200=
> AND date=3D... etc.=20
> We got about 5 times slower performance with compare to MS SQL 7.0.=20
Not enough info here. What is the exact declaration of the table and
each index? What is the exact query, and what does EXPLAIN show for it?
Also, if you haven't run a VACUUM ANALYZE on the table, it may help to
do that.
regards, tom lane