dbfiles a placed in %APPDATA%
user/password: monetdb/monetdb
autocommit ON seems to be better (even for reading)
Note: it seems that rows are returned when all the sql query has been executed ...
Data content on very big tables never ends (when it works for other RDBMS that only fetch the 100 firts rows).
To avoid this please use syntax editor with Sql syntax:
Select
...
from
table
limit 1000
Any feedback on this RDBMS is wellcome
Regards
PAscal
Last edit: PAscal 2014-01-26
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The columnar rdbms monetDB works fine with analytical queries on big data.
Here are some informations to use SQLeo on the default install:
driver: nl.cwi.monetdb.jdbc.MonetDriver
url: jdbc.monetdb://localhost/demo
dbfiles a placed in %APPDATA%
user/password: monetdb/monetdb
autocommit ON seems to be better (even for reading)
Note: it seems that rows are returned when all the sql query has been executed ...
Data content on very big tables never ends (when it works for other RDBMS that only fetch the 100 firts rows).
To avoid this please use syntax editor with Sql syntax:
Select
...
from
table
limit 1000
Any feedback on this RDBMS is wellcome
Regards
PAscal
Last edit: PAscal 2014-01-26