- users-list - monetdb.org

[MonetDB-users] Tweaking performance
by Garrett Smith 22 Apr '09

22 Apr '09

123456789012345678901234567890123456789012345678901234567890123456789012 Does anyone have some guidance on approaches for optimizing database performance? I realize this is a pretty broad question :) More specifically, I'm running a simple query select max(date) from metric on a table with 21 million rows (or whatever you call them in Monet). It's taking quite a bit longer than I'd expect, given a typically indexed column. On an "explain" I see that there's no difference between the plan with or without the presence of an index on 'date'. Per the SQL index docs, I see that indexes are more of a hint to Monet and they're often ignored. Cool. But what happens when I want to fix what seems to be a configuration problem with my database/schema? Thanks! Garrett

1 0

Re: [MonetDB-users] the x100 project
by Peter Boncz 21 Apr '09

21 Apr '09

Hi Tom, Thanks for your interest in X100. The project is very much alive in a recent CWI spin-off company called vectorwise. X100 is currently being developed into a fully functional database engine that will fly in datawarehousing and BI environments. Much more than that I cannot say about it now. More news will follow, certainly within a year. It is not yet open source (but in a future that is not off the cards), but if you need that now, you could try MonetDB. Peter > Hello, > I have been asked to evaluate MonetDB. We have interest in the x100 project, is this project still on going... is there a download for it? If > not, is there a plan to release it? > > thanks > tom

1 0

[MonetDB-users] monetdb-client ubuntu package missing binary ?
by Franck Routier 18 Apr '09

18 Apr '09

Hi, I have tried to install and test monetdb using ubuntu repository. But when it comes to using mclient, no binary seems to be installed. Indeed, looking at the package, there seems to be only docs in it. So, am I looking at the wrong place and missing some obvious point, or is the package broken ? (notice that the debian package seems to be similar) Thanks, Franck

2 4

[MonetDB-users] the x100 project
by tom edgar 17 Apr '09

17 Apr '09

Hello, I have been asked to evaluate MonetDB. We have interest in the x100 project, is this project still on going... is there a download for it? If not, is there a plan to release it? thanks tom

1 0

[MonetDB-users] loading big table
by dariuszs 16 Apr '09

16 Apr '09

Hi, I've got a table with 130 fields. When I load 130 million records into that table (about 50G) - it's not a problem, but when I try to load 160 million records (about 60G of data) into it this thing just sits for hours with no error messages. Can somebody help me? Thanks. Dariusz.

5 16

[MonetDB-users] MonetDB XQuery in Production
by Max Fedorov 14 Apr '09

14 Apr '09

The product looks very promising on paper, although not that many people are talking about it and I came across MonetDB by accident. Is anyone using MonetDB in production? Is the product stable enough? I do not feel like spending lots of time testing this XQuery server if nobody runs it in production. I loaded several million records and tested sample queries without issues for the most part, but then once the server just vanished (running latest 32bit version on WindowsXP). I restarted and everything is working again, but now I am very scared. Nothing like this ever happened when using MySQL, MS SQL Server or Oracle. Nothing ever just dies without a trace. Thank you. -Max

4 5

[MonetDB-users] timer option in monetdb
by Mayank Maheshwari 14 Apr '09

14 Apr '09

Hi, I'm working on a project comparing the performance of column-store database systems using MonetDB with the common row-stores for different query scenarios. While running the --timer option on monetDB, I was wondering if it includes the time for printing the result and any other I/O time as well. I'm trying to get the break-up of where the system spends its time while processing the query. Is there a way I could find that out? Also is it possible to find out whats the compression scheme the database is using to store the data? I'm storing a 1 million row table with 6 attributes. Thanks. Mayank Maheshwari mayank(a)cs.wisc.edu

1 0

[MonetDB-users] Fast Loading
by Alex Bo. 14 Apr '09

14 Apr '09

Hi, I came across chapter 3.2.8 in the documentation regarding 'Fast Loading'. I am trying to use it in order to improve the performance I get compared to loading tables using 'COPY INTO'. However, I am not sure how to approach this: "Each file is produced by a program that writes the binary image of the BAT directly, i.e. a binary dump of an C-array" How exactly can I produce these binary images from my source columns? How exactly are they expected by MonetDB to look like? A little more info could be very helpful. Thanks. -- View this message in context: http://www.nabble.com/Fast-Loading-tp23009932p23009932.html Sent from the monetdb-users mailing list archive at Nabble.com.

5 4

[MonetDB-users] mysql vs. monetdb
by Yue Sheng 08 Apr '09

08 Apr '09

Hi, we installed MonetDB on a Linux box, and did some comparison between MySQL and MonetDB. The result seems off by a large magnitude. Has anyone encountered similar problem please? Thanks. For MonetDB: ql>select count(ins_key) from bigtable where ins_key = 15012; +---------+ | L1 | +=========+ | 1931541 | +---------+ 1 tuple Timer 260771.478 msec 1 rows For MySQL: select count(ins_key) from bigtable where ins_key=15012; +----------------+ | count(ins_key) | +----------------+ | 1931548 | +----------------+ real 0m0.989s user 0m0.002s sys 0m0.003s Indices: MonetDB: None MySQL: index on ins_key Thanks.

3 4

[MonetDB-users] Admin GUI not working on Vista 64
by Max Fedorov 08 Apr '09

08 Apr '09

Installed 64 bit version of MoneyDB on Vista. Server and client are working fine, but Admin GUI is coming up with 404. Thanks. -Max

2 4