Hi Richard, I'd suggest to working with indexes in the database.
Jacopo Richard Fleming wrote:
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
