From: Peter Sap (psapxs4all.nl)
Date: Sun Nov 16 2003 - 09:38:45 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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" <chrisimi.com.au>
To: <mysqllists.mysql.com>
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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]