One column per MyISAM table, I think you mean: each column in a MyISAM table would also be a column in Sybase IQ. The disk requirements in IQ would be different since IQ uses a compression technique. Since storage is column-based the compression can be done more efficiently. I work primarily at Sybase sites and everybody says that the query performance is very good. You can run into problems when loading data: only one session at a time can update a single table (many readers but only one writer)
Peter Sap ----- Original Message ----- From: "Chris Nolan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 14, 2003 12:11 AM Subject: Analytic database? > 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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]