Dave Watts wrote: >>> I'm pretty much dealing with a single table. It's roughly >>> 800 records with around 1200 columns. >> if you don't mind me saying, there's something wrong here. > > Maybe they're all bit datatypes.
even if they came w/ice cream, 1200 columns is too many, smells like "spreadsheet-ism". even if the rows describe some "state" you could just pack the bits. love to see some of the WHERE clauses ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
