------------------ Original ------------------
From: "Martin Kersten";<Martin.Kersten@cwi.nl>;
Date: Wed, Apr 30, 2014 05:38 PM
To: "users-list"<users-list@monetdb.org>;
Subject: Re: »Ø¸´£º why the same procedure (in shell or in sql) cost so differenttime?
On 30/04/14 11:27, integrity wrote:
> Hi,
...
>
> On 30/04/14 10:59, integrity wrote:
> > Hi All,
> > I want to execute a batch of small sql stored procedures, for
> convenience, i put them totally in another big stored procedure:
> gwac_uniquecatalog, it cost 58 minutes:
> > #!/bin/bash
> > time mclient -d mydb -s "CALL gwac_uniquecatalog(99);"
> > real 58m3.518s
> >
> > The time is so long that I tried to execute the small stored
> procedures one by one in SHELL, it only cost 6.5 minutes
> > /usr/bin/time ./gwac_uniquecatalog.sh 99
> > 2.82user 3.25system 6:30.39elapsed 1%CPU (0avgtext+0avgdata
> 10880maxresident)k
> > 0inputs+0outputs (0major+980011minor)pagefaults 0swaps
> >
What were the numbers of /usr/bin/time for the long run?
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
.