[ic] Number of products and database normalization

[Paul Jordan]

> 1. I seem to have a performance problem. I have loaded my client's DB w/
> 38,000 sku's. When I ran the foundation store it was nice and snappy. Now
> with the new data loaded it's slow (10-20 sec a page load). I'm use
> PostgreSQL as a back end and I logged everything for analysis and created
> indexes as needed (and vacuuming). I don't have any select queries (with
> WITH) not hitting an index, but it's still too slow. I have my PostgreSQL
> buffers up to 2048.
> Is anyone running Interchange with this many products and how is the
speed?


Which pages are slow to load? are you doing complex conditionals? Have you
seen...

http://www.icdevgroup.org/cgi-bin/ic/docfly.html?mv_arg=icfaq14.02

paul