[MonetDB-users] Creating table with nologging.
I have the need for creating table with nologging enabled. I do understand that MonetDB is not meant to be used this way. However, I am trying to use it to ingest data off data-feeds. My db lives on a SSD, and the only DML that I execute is INSERT. I would appreciate if folks familiar with the server code could point me source files where I could make the change to achieve this. Thanks in advance for your help.
-- Shailendra
On Tue, Jul 27, 2010 at 04:28:56PM -0700, Shailendra Mishra wrote:
I have the need for creating table with nologging enabled. I do understand that MonetDB is not meant to be used this way. However, I am trying to use it to ingest data off data-feeds. My db lives on a SSD, and the only DML that I execute is INSERT. I would appreciate if folks familiar with the server code could point me source files where I could make the change to achieve this. Thanks in advance for your help.
-- Shailendra
Shailendra
I haven't tried this in a while but it used to be possible to switch logging of inserts of using a debug flag (passed to the logger code).
See the file src/storage/bat/bat_logger.mx function bl_create. The first argument to logger_create should be 128 to switch off logging.
This will only disable that every insert will also write the inserted values to the log. It still creates a log for your initial create table statement.
Indeed this is un documented and far from normal supported usage of monetdb.
Niels
The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://ad.doubleclick.net/clk;226879339;13503038;l? http://clk.atdmt.com/CRS/go/247765532/direct/01/
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Niels Nes
-
Shailendra Mishra