For question (a) there are too many variables about your environment for anyone to benchmark against. As for (b), MonetDB doesn't pay attention to user specified indexing. For the query you ran, did you run it twice in a row? Was the system swapping during the query? On Fri, Mar 20, 2009 at 11:58 AM, Yue Sheng <yuesheng8@gmail.com> wrote:
I have a table with 700million rows, and 14 columns. All doubles. Each column of data have non-unique entries. No indexing. My query:
SELECT * FROM bigtable WHERE col4 < 1000 limit 100;
took 35 minutes to run.
(a) Is this about the average time to run? (b) Should I explicitly index col4? (Website seems to suggest MonetDB takes care of indexing automatically) If so, how much benefit should I expect?
Thanks.
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users