Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - Ingres  »  [Info-Ingres] Allowing integer constants to be...
Page 1 of 1    

[Info-Ingres] Allowing integer constants to be...

Author Message
Martin Bowes...
Posted: Tue Oct 27, 2009 1:04 pm
Guest
Hi All,



I've worked out how to munge the Opensource to allow me to express
integer constants in k....only 4 files need to be altered, its really
sweet!



This allows us to do things like:

create table x (a integer) with page_size=8k;

modify x to hash unique on a with minpages=120k;

insert into x(a) values(5k);



etc...



The 'k' is case insensitive, it could be a 'K'.



Before I go through the hassle of submitting a DDS etc I was wondering
if there was any desire to allow megabytes, Gigabytes etc.



Martin Bowes
 
Ingres Forums...
Posted: Tue Oct 27, 2009 3:26 pm
Guest
I refer you to the comments Karl made on the desirability of supporting
huge data page sizes for data warehousing (right at the end).

'Potential Catalog Updates - Ingres Community Wiki'
(http://community.ingres.com/wiki/Potential_Catalog_Updates)

At some point we may see multi-megabyte page sizes (!), so why limit it
whilst you are already messing with the code.


--
nick.bolton at (no spam) barclays.com
------------------------------------------------------------------------
nick.bolton at (no spam) barclays.com's Profile: http://community.ingres.com/forum/member.php?userid=733
View this thread: http://community.ingres.com/forum/showthread.php?t=11286
 
 
Page 1 of 1    
All times are GMT
The time now is Thu Nov 26, 2009 6:27 am