fyi, http://dev.mysql.com/doc/refman/5.6/en/column-count-limit.html 4K columns max for mysql in general 1K columns max for innodb 64K row limit is not an issue, ours will be ~20K Jacek On 06/06/2013 12:24 PM, Jacek Becla wrote: > Hi Fabrice, > > I documented a new test that we need to run: > > https://dev.lsstcorp.org/trac/wiki/db/tests/MySql/WideTables > > this one is critically important to do before Aug 6-7 > database review (and the Final Design Review). We need > to get a feel how difficult it'll be to work with very wide > tables in mysql. This is new, our widest table used to be > 500 columns, but lsst scientists are now proposing a new > model that involves 4900 columns in our Object table. > > I realize this will take a non-trivial effort to run. > If you won't be able to run it (or if you have any questions > at all), let me know, and we will try to get something > going ourselves here, at slac. > > thanks! > Jacek ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1