Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.8.8) with ESMTP id FAA03472 for ; Wed, 14 Oct 1998 05:45:12 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from [194.90.105.28] (herouth@[194.90.105.28]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id LAA09832; Wed, 14 Oct 1998 11:44:51 +0200 (IST) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 14 Oct 1998 11:46:13 +0200 To: Eric McKeown , PGsql From: Herouth Maoz Subject: Re: [SQL] dilemma At 4:24 +0200 on 14/10/98, Eric McKeown wrote: > Is there a better way to design this? I thought about making the option > ids for each vehicle a comma-delimited text field, but maybe the search > would be even slower if I did that. Since I'm not a SQL expert, I don't > know, but I'm asking all the experts out there--how should I set this > thing up?? Your solution is the best, most classic solution. You just need to index the relational table properly (Put an index on each of the fields). Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma