OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Analytic database?

From: Chris Nolan (chrisimi.com.au)
Date: Thu Nov 13 2003 - 17:11:34 CST


Hi all,

Has anyone here seen or heard anything concrete about Sybase iQ (other
than Sybase's performance claims). They say that the basis of their new
engine is "analytics", not transactions. A Google search turned up
nothing of technical merit and the whole idea seems to be using seperate
storage for each column and compressing all data (not per record, as in
the entire column is compressed as a whole). Would one be able to have
one column per MyISAM table and get a similar performance (while
obviously still retaining the same disk requirements and possibly
loosing out due to the additional IO required to pull data in and write
it out)?

Regards,

Chris

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql