Re: [PERFORM] Large querie with several EXISTS which will be often runned

2003-06-28 Thread Shridhar Daithankar
On Saturday 28 June 2003 14:47, Bruno BAGUETTE wrote: > Do you mean this query ? > > SELECT > products_options_groups.pk_prdoptgrp_id,products_options_groups.prdoptgr > p_name > FROM products_options_groups > WHERE EXISTS > ( > SELECT * > FROM products_options_classification > INN

RE : [PERFORM] Large querie with several EXISTS which will be often runned

2003-06-28 Thread Bruno BAGUETTE
Hello Josh, > > I will have to manage more or less 10.000 products with > more or less > > 2-3 options by products and more or less 40 options-groups. > > > > Do you think that this query will be hard for PostgreSQL (currently > > 7.2.1 but I will migrate to 7.3.2 when going in production > >

Re: [PERFORM] Large querie with several EXISTS which will be often runned

2003-06-27 Thread Josh Berkus
Bruno, > I will have to manage more or less 10.000 products with more or less 2-3 > options by products and more or less 40 options-groups. > > Do you think that this query will be hard for PostgreSQL (currently > 7.2.1 but I will migrate to 7.3.2 when going in production environment) > ? > How ca

[PERFORM] Large querie with several EXISTS which will be often runned

2003-06-27 Thread Bruno BAGUETTE
Hello, I've a performance question that I would like to ask you : I have to design a DB that will manage products, and I'm adding the product's options management. A box can be red or yellow, or with black rubber or with white rubber, for example. So I have a product (the box) and two options gr