Re: maximum number of columns & max row size

2002-08-01 Thread Michael Zelina
to worry about cleanup. Read up > on temporary tables, I think they would help you considerably in this > situation. > > > On Thursday, August 1, 2002, at 01:39 PM, Michael Zelina wrote: > >> Hi Brent, >> >> Thanks for the response. Currently, I have the varia

Re: maximum number of columns & max row size

2002-08-01 Thread Michael Zelina
and names, since there are only two columns. You > couldn't index all your columns if you expanded horizontally instead of > vertically. Besides, it's a heck of a lot easier to add a row than a > column. > > > On Thursday, August 1, 2002, at 01:09 AM, Michael Zelina

maximum number of columns & max row size

2002-07-31 Thread Michael Zelina
Can someone provide insight into what a good maximum number of columns is in a MySQL database? I have an extensive list of variables for an engineering application which number in the 700+ range with more additions possible down the road. My question is: should I break up the variables into sev

how to have read-only table files (.myi, .myd, .frm)

2002-07-29 Thread Michael Zelina
I am wondering if I can somehow have tables read only at the OS level and still have MySQL work as normal (at least for SELECTs). I can make the table files read only, but when I try to select something, I get the error similar to "your_table.MYD cannot be found". The funny thing is if I change t