RE: Max columns in a tabel in MyISAM storage engine

2007-04-17 Thread Fabian Köhler
rmance? i only got very slow implementations. also see this link: http://www.wormus.com/aaron/stories/2007/03/23/mysql-restructuring-data-for-a-view.html i just thought so, because it would be very handy to read and update data that way (altough the updates on that view doesn't seem to be possi

Re: Max columns in a tabel in MyISAM storage engine

2007-04-17 Thread Fabian Köhler
There is another question coming to my mind: is it possible to define a view which has more columns then or does the same limits for a normal table apply to a view? regards, Fabian On Mon, 16 Apr 2007 23:39:40 -0700, "Micah Stevens" <[EMAIL PROTECTED]> said: > Fabian Köhl

Re: Max columns in a tabel in MyISAM storage engine

2007-04-17 Thread Fabian Köhler
which are necessary to create such tables. desired table: id|q1|q2|q3 1|answer1|answer2|answer5 2|answer3|answer4|asnwer6 regards, Fabian On Mon, 16 Apr 2007 23:39:40 -0700, "Micah Stevens" <[EMAIL PROTECTED]> said: > Fabian Köhler wrote: > > Hello, > > > >

Re: Max columns in a tabel in MyISAM storage engine

2007-04-17 Thread Fabian Köhler
ere will alway be a limit to the max. amount of answers in the system. regards, Fabian On Mon, 16 Apr 2007 23:39:40 -0700, "Micah Stevens" <[EMAIL PROTECTED]> said: > Fabian Köhler wrote: > > Hello, > > > > i have table with answers to questions. Every answer i

Max columns in a tabel in MyISAM storage engine

2007-04-16 Thread Fabian Köhler
have more answers than columns available? Does anybody have an idea? VIEWs or GROUP_CONCAT doesn't seem to be an option, they are all to slow. What's the "right" way to store and select such information? Thank you very much. regards, Fabian -- Fabian Köhler http://