Hi all -
I ran about 100,000 products (1/10th of our total) into OFBiz and generated
keywords for them. Now the keyword searches are very slow and can take 30sec to
complete. I used the psql COPY command to populate the products table and then
clicked the "generate keywords for all items" button. When that finished, I
vacuumed/analysed the database.
I'm using Postgresql 8.1 on a 2gz machine running windows xp - only 512 in
memory though. We have a larger database on this machine which searches
description for these products and we use the TSearch type and it's very fast...
Is there a setting in the framework that I need to tweak or setup to enable
faster keyword searches?
Thanks in advance!
Rick
