[ic] Product Meta DB Lookup issue

Kevin Walsh kevin at cursor.biz
Tue Aug 29 09:04:49 EDT 2006


"N.E.S.T. Solutions" <nest_consulting at yahoo.ca> wrote:
> My tables columns are built like this: 
> 
> Products table: 
> sku description price (...) itemtype1 itemtype1brand (...) itemtype2
> itemtype2brand (...) 
> [around 250 columns, 20 item types]
> 
Have you  considered splitting the 250 columns into a separate table?
Perhaps one table with sku, description and price etc. and another with
sku, type and brand?

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/


More information about the interchange-users mailing list