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 environment)

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 INNER JOIN