On Wed, Jun 18, 2008 at 05:28:29PM +0100, Sam Mason wrote:
On Wed, Jun 18, 2008 at 06:18:02PM +0200, Niels Nes wrote:
On Wed, Jun 18, 2008 at 12:34:13PM +0100, Sam Mason wrote:
I'm not sure I thought of specifying it, every other database I've used hasn't been limited by address space size in this way :) We like to be special ;-).
there's always one isn't there :)
Indeed the current primary key check is (in out of memory situations) bad as it trashes swap (ie close to random access on a large column).
OK, how much of a change to the code do you think it would be to remove this behavior? I'm reasonably proficient in C, the thing that tends to take time is learning the structure of a new codebase.
Depends on how you want to solve it. Current code uses a hash solution a clustered hash or sorted solution would work better (less random io). The code for schema altering sql statements is layered as follows sql parser, semantic checks,generate a tree of the needed 'mal' instructions, optimizers, generate mal. So adaption of the code in sql_schema/sql_updates would be needed possibly with a new index structure to support the more advanced key checks (clusters/ordered index). This is not a task some one new at MonetDB should start at. There are better 'introductionary' tasks by which you could slowly learn the system. One such task would be the addition of new functions, ie c-functions which can be called from sql. From the feature requests for example I know we would like more advanced time/date output format functions. Niels
Sam
------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl