Re: {Spam?} RE: Can I optimize the engine here or do I have to get the developers to change the SQL?

On 8 Nov, 11:20, Obnoxio The Clown <obno...@serendipita.com> wrote: > Ian Michael Gumby wrote: > > >  > Date: Sat, 7 Nov 2009 22:20:27 +0000 > >  > From: obno...@serendipita.com > >  > CC: informix-l...@iiug.org > >  > Subject: Re: Can I optimize the engine here or do I have to get the > > developers to change the SQL? > > >  > Ian Michael Gumby wrote: > > >  > > The only other 'must have' feature would be to create a column > > oriented > >  > > data type (re: HBase). This shouldn't be too hard to build on. > > Something > >  > > similar to the time series datablade. > > >  > Fuck. Off. > > >  > Firstly, it's nothing like the fucking time series DataBlade and > >  > secondly, it's an affront against nature. > > >  > Stick your HBase-alike into DB2, where it can sit alongside the equally > >  > immensely valuable and productive native XML support. > > > Ah, you don't really know how the time series datablade works, do you? > > So if you think about it, a column oriented datablade would use a lot of > > the same basic concepts in terms of memory and page storage. > > Really. Gosh, well, who would have thunk that a column oriented > DataBlade would also use memory and pages? Certainly not me. > > > Yeah there's more to it and the distributed query management would be > > different, but IDS would be the easiest database to implement these > > concepts. > > Yeah, apart from those minor issues, huh? And one other minor issue: who > wants this shit apart from you? > > > While you may see this as an abomination, others have been very > > successful in implementing this. > > Yeah, it's taking over the RDBMS market. Oracle for one are absolutely > shitting themselves. > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. Well the people who use Sybase IQ certainly think column orientated databases are worthwhile plus it would be a feature to compete with the other database products.