Is there any method, besides restarting the database,
of shrinking the sql log file?
When I am performing a large set of large inserts (via
COPY INTO) the log file gets very large. I wish there
was a way to cycle the log file.
Also during these large batches of inserts the
database server becomes less and less responsive until
I am forced to restart the server. Upon restart and
the normal recovery monet returns to a very responsive state.
hi,
I am a beginner of MonetDB. I want to run TPC-H benchmark on MonetDB. I
found there are SQL queries and related files under monetdb source folder
<monetdb-source>/sql/src/benchmark/tpch. I ran the script 'run.all'. But
that gave me many errors and did not succeed. Can anyone describe briefly
the steps I need to carry out in order to run TPC-H benchmark? Any
documentations I can refer to is highly appreciated.
Thank you.
--
View this message in context: http://www.nabble.com/how-to-run-TPC-H-benchmark-on-MonetDB-tf4524693.html#…
Sent from the monetdb-users mailing list archive at Nabble.com.
how we minus 10 minutes from current_timestamp.
because i have to fetch all the records from a table 10 minutes before
currenttimestamp.
so pls tell me how we deternine 10 min before timestamp value.
Thanks
pawan
--
View this message in context: http://www.nabble.com/minus-10-minutes-from-current_timestamp-tf4526685.htm…
Sent from the monetdb-users mailing list archive at Nabble.com.
I want to select records from a table on the basis of date in MonetDB and
then insert all these selected records in a table i.e. present in oracle
using C or Pro*C.
can any one help me in writing the code.
Thanks in advance.
Pawan
--
View this message in context: http://www.nabble.com/I-want-to-select-records-from-MonetDB-tf4514715.html#…
Sent from the monetdb-users mailing list archive at Nabble.com.
Hi,
What's the good database tool that I can use to connect to MonetDB, run
queries and browse the objects?
I used to use DBVisualizer earlier and now both 5.1.1 and 6.0.x version are
giving errors. I installed the latest version of the MonetDB couple of weeks
ago and I think the changes in the new version of MonetDB (JDBC) are causing
these issues.
Thanks,
-Venks
Hi,
I want to construct a Monet client app in C on Windows but find very
sparse info on this. I took notice of the fact that Windows is
apparently not exactly Monet's main target platform. Still, I tried
using nmake on the client sources but ran into errors involving missing
(or incorrectly placed) files (see below). Do I really have to go
through the complete 'Experts > Windows Installation', i.e. building
MonetDB server itself?
regards,
Sander
...\clients-1.18.2\src\mapilib>nmake -f makefile.msc
Microsoft (R) Program Maintenance Utility Version 8.00.50727.42
Copyright (C) Microsoft Corporation. All rights reserved.
makefile.msc(8) : fatal error U1052: file '.\..\..\rules.msc' not found
Hello all,
I've downloaded MonetDB XQuery for evaluating the XQuery Update
Facility. I've shredderd a document and can perform xqueries from
MapiClient successfully. But, when i try to update a document, the
process fails with error message: !ERROR updating read-only document.
May i have to specify some flags or something else???
Thx
Timothy
