On Fri, May 13, 2011 at 01:27:13PM +0200, Fabian Groffen wrote:Indeed.
> On 13-05-2011 12:54:05 +0300, Georgios Garmpis wrote:
> > To be more clear,
> >
> > I cannot figure out the reason why mserver acts like that.
> >
> > Query doesn't seem very complicated to me.
> > Should i refine my query or is it a problem of mserver (e.g. configuration
> > issue, bug etc)?
>
> Try prefixing EXPLAIN to your "simple" query, and you'll get an idea
> what mserver is doing for you to perform the query.
Maybe you could prefix your query with both PLAN and EXPLAIN (one at a time)
and share both results with us to see how MonetDB translates your query.
Also: how large is your data, i.e., how many records are there in the tables
involved, and how large (number of records) is the expected result of your
query?
Stefan
--
> ------------------------------------------------------------------------------
> Achieve unprecedented app performance and reliability
> What every C/C++ and Fortran developer should know.
> Learn how Intel has extended the reach of its next-generation tools
> to help boost performance applications - inlcuding clusters.
> http://p.sf.net/sfu/intel-dev2devmay
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
| Stefan.Manegold @ CWI.nl | DB Architectures (INS1) |
| http://CWI.nl/~manegold/ | Science Park 123 (L321) |
| Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users