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
-- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl