On 25 Feb 2011, at 10:03pm, Greg Barker wrote: > Thanks for the responses guys. > >> I would never have any table with 150 columns. It should be possible to >> keep the schema for your table in your head. > > Unfortunately those are the cards I have been dealt. The columns are just > buckets of data (bucket1, bucket2, bucket3, etc). Each bucket could be 1 > month or 1 weeks worth of data, it can vary from table to table. They can > have up to two years worth of data loaded, so that could be 24 monthly > buckets or 104 weekly buckets.
So your schema really should have a table with 'bucketNumber' and 'bucketContents' as columns. That would make every bucket a separate row. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
