Thanks guys, I'll look into the indexing and let you know what I find. Rick
Jacopo Cappellato <[EMAIL PROTECTED]> wrote: 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 >
