Data storage capacity in monetdb
I installed the version of windows for monetdb http://www.monetdb.org/Downloads. I installed a database column, but when I went over 30 GB of stokage given. the query response time has become very slow. Please, I have two questions:
- Are this version is limited or no storage ?
- I have noticed that the name of the database is by default "demo". Can i create another one with this version with 1 TB?
Hello Khaled,
On 05/02/13 23:32, KHALED DEHDOUH wrote:
I installed the version of windows for monetdb http://www.monetdb.org/Downloads. I installed a database column, but when I went over 30 GB of stokage given. the query response time has become very slow.
It might be that your "hot set", that is, the amount of data used by your queries, has outgrown the size of your physical memory. This wil lead to increased IO with the hard disk, and thus degraded performance. You might be able to reorganize your data or reformulate your query to increase performance.
Please, I have two questions:
- Arethis version is limited or no storage ?
No, there is no "Pro" version of MonetDB, and there are no limits on number of CPUs, main memory or database size on disk from our side. MonetDB is free software (see http://www.monetdb.org/Legal/MonetDBLicense for licensing terms).
- I have noticed that the name of the database is by default "demo". Can i create another one with this version with 1 TB?
Yes, you can create an arbitrary number of databases. See the MonetDB tutorial for details at http://www.monetdb.org/Documentation/Tutorial .
If you have further questions, let us know.
Best,
Hannes
----- Original Message -----
Hello Khaled,
On 05/02/13 23:32, KHALED DEHDOUH wrote:
I installed the version of windows for monetdb http://www.monetdb.org/Downloads. I installed a database column, but when I went over 30 GB of stokage given. the query response time has become very slow.
It might be that your "hot set", that is, the amount of data used by your queries, has outgrown the size of your physical memory. This wil lead to increased IO with the hard disk, and thus degraded performance. You might be able to reorganize your data or reformulate your query to increase performance.
See also http://www.monetdb.org/Documentation/UserGuide/resources
Please, I have two questions:
- Arethis version is limited or no storage ?
No, there is no "Pro" version of MonetDB, and there are no limits on number of CPUs, main memory or database size on disk from our side. MonetDB is free software (see http://www.monetdb.org/Legal/MonetDBLicense for licensing terms).
- I have noticed that the name of the database is by default
"demo". Can i create another one with this version with 1 TB?
Yes, you can create an arbitrary number of databases. See the MonetDB tutorial for details at http://www.monetdb.org/Documentation/Tutorial .
If you have further questions, let us know.
Best,
Hannes _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 2013-02-06 09:28, Hannes Mühleisen wrote:
Hello Khaled,
On 05/02/13 23:32, KHALED DEHDOUH wrote:
I installed the version of windows for monetdb http://www.monetdb.org/Downloads. I installed a database column, but when I went over 30 GB of stokage given. the query response time has become very slow.
It might be that your "hot set", that is, the amount of data used by your queries, has outgrown the size of your physical memory. This wil lead to increased IO with the hard disk, and thus degraded performance. You might be able to reorganize your data or reformulate your query to increase performance.
Please, I have two questions:
- Arethis version is limited or no storage ?
No, there is no "Pro" version of MonetDB, and there are no limits on number of CPUs, main memory or database size on disk from our side. MonetDB is free software (see http://www.monetdb.org/Legal/MonetDBLicense for licensing terms).
- I have noticed that the name of the database is by default
"demo". Can i create another one with this version with 1 TB?
Yes, you can create an arbitrary number of databases. See the MonetDB tutorial for details at http://www.monetdb.org/Documentation/Tutorial .
On Windows, the database name is fixed to the default by the scripts and Start menu entry with which the server and client are started. Take a look at the *.bat files in c:\Program Files\MonetDB\MonetDB5.
You can modify or make a modified copy of M5server.bat or MSQLserver.bat and add an argument --dbname=new-name. Changing the latter is probably easier: add the argument to the invocation of the M5server.bat script.
You will also have to do something to how you call the mclient.bat script.
If you modify the scripts, it affects the server and client that are started when you use the Start menu entries, but there is no problem if you start the server from the command line with extra arguments, so you can just as easily start the server from the command line like this:
"C:\Program Files\MonetDB\MonetDB5\MSQLserver" --dbname=whatever
If you have further questions, let us know.
Best,
Hannes _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender
participants (4)
-
Hannes Mühleisen -
KHALED DEHDOUH -
Sjoerd Mullender -
Stefan Manegold