Re: Performance aggregates

On Tuesday 15 May 2001 14:40, you wrote:
> Hello,
>
> I have 2 tables :
>
> CREATE TABLE e_kalkn (
> id INT4 NOT NULL,
> roba VARCHAR(6) NOT NULL,
> dat DATE NOT NULL,
> datv DATE NOT NULL,
> val VARCHAR(3) NOT NULL,
> kod VARCHAR(3) NOT NULL,
> tb VARCHAR(2) NOT NULL,
> ts VARCHAR(2) NOT NULL,
> dob VARCHAR(6),
> status VARCHAR(1)
> );
> CREATE TABLE e_kalkns (
> id INT4 NOT NULL,
> redbr INT NOT NULL,
> osn NUMERIC(30,6),
> proc NUMERIC(30,6),
> izn NUMERIC(30,6)
> );
>
> and indexes :
>
> create unique index e_kalkn_id on e_kalkn(id);
> create index e_kalkns_id on e_kalkns(id);
>
> Table e_kalkn have 4668 rows and e_kalkns 101170 rows.
>
> Query :
>
> select roba,sum(izn)
> from e_kalkn k,e_kalkns ks
> where k.id=ks.id
> group by roba
> order by roba
>
> is 2.5 times faster on one commercial database (there are tests on Internet
> that say 'Postgresql is faster than that database).
> I can't say which database it is.
>

MySQL is 2.5 times faster, too.

regards,