> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 17, 2005 10:44 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] Proposal: limit the number of columns > in a table to 2000. > > Darn, I was going to have 500,000 columns in my table. The, > each column > would be named like this: Record1, Record2, Record3, and so on up to > Record5000000. Each column type was going to be varchar and I > was going to > store my first record in xml format in my Record1 column of > the first row, > and so on down the line. That way I could stored all 500,000 > of my records > in a 1 row table, What do you guys think?
Definitely needs an index. On each column. In all seriousness, 2000 columns is plenty. Does that ceiling apply to joins as well, such that no more than 2000 columns are returned from a select clause? Or does it only apply per-table? Robert
